转载-How to rename everything on Oracle Database (re-mysql教程-PHP中文网

首页

数据库

mysql教程

转载-How to rename everything on Oracle Database (re

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:36 PM

rename

看到一遍关于oracle rename 语法的总结文章，特转载于此原文地址 Renaming redolog members; Renaming tablespaces; Renaming datafiles of a single offline tablespace; Renaming constraints; Renaming schema objects (tables, views, sequences, privat

看到一遍关于oracle rename 语法的总结文章，特转载于此原文地址

Renaming redolog members;
Renaming tablespaces;
Renaming datafiles of a single offline tablespace;
Renaming constraints;
Renaming schema objects (tables, views, sequences, private synonyms, indexes, triggers);
Renaming table columns;
Renaming table and index partitions (subpartitions);
Restoring and Renaming table from the Recycle Bin;
Changing the domain in a global database name for a CDB;
Renaming a PDB;

Let’s review them with few examples.

Renaming redolog members:

To complete this requirement you have to shutdown the database, move the redo log files to the new destination, startup the database in mount mode, rename the log members and then open the database.

[oracle@localhost admin]$ sqlplus / AS sysdba
?
SQL*Plus: Release 12.1.0.1.0 Production ON Wed Mar 12 16:16:04 2014
?
Copyright (c) 1982, 2013, Oracle.  ALL rights reserved.
?
?
Connected TO:
Oracle DATABASE 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
WITH the Partitioning, OLAP, Advanced Analytics AND REAL Application Testing options
?
SQL>  SET LINES 180                        
SQL>  col member format a50
SQL>  SELECT GROUP#, MEMBER, CON_ID FROM V$LOGFILE;
?
    GROUP# MEMBER        CON_ID
---------- -------------------------------------------------- ----------
  1 /app/oracle/oradata/CDB001/redo01.log         0
  2 /app/oracle/oradata/CDB001/redo02.log         0
  3 /app/oracle/oradata/CDB001/redo03.log         0
?
SQL>  shutdown immediate;
DATABASE closed.
DATABASE dismounted.
ORACLE instance shut down.
SQL>  host mv /app/oracle/oradata/CDB001/redo01.log /app/oracle/oradata/CDB001/redo01_renamed.log
?
SQL>  host mv /app/oracle/oradata/CDB001/redo02.log /app/oracle/oradata/CDB001/redo02_renamed.log
?
SQL>  host mv /app/oracle/oradata/CDB001/redo03.log /app/oracle/oradata/CDB001/redo03_renamed.log
?
SQL>  host ls -l /app/oracle/oradata/CDB001/*log
-rw-r-----. 1 oracle oinstall 52429312 Feb  7 15:59 /app/oracle/oradata/CDB001/redo01_renamed.log
-rw-r-----. 1 oracle oinstall 52429312 Mar  3 13:00 /app/oracle/oradata/CDB001/redo02_renamed.log
-rw-r-----. 1 oracle oinstall 52429312 Mar 12 16:17 /app/oracle/oradata/CDB001/redo03_renamed.log
?
SQL>  startup mount;
ORACLE instance started.
?
Total System Global Area  626327552 bytes
Fixed Size      2291472 bytes
Variable Size    473958640 bytes
Database Buffers   146800640 bytes
Redo Buffers      3276800 bytes
Database mounted.
SQL>  alter database rename file '/app/oracle/oradata/CDB001/redo01.log','/app/oracle/oradata/CDB001/redo02.log','/app/oracle/oradata/CDB001/redo03.log'
  2  to '/app/oracle/oradata/CDB001/redo01_renamed.log','/app/oracle/oradata/CDB001/redo02_renamed.log','/app/oracle/oradata/CDB001/redo03_renamed.log';
?
Database altered.
?
SQL>  alter database open;
?
Database altered.
?
SQL>  select GROUP#, MEMBER, CON_ID from V$LOGFILE;
?
    GROUP# MEMBER        CON_ID
---------- -------------------------------------------------- ----------
  1 /app/oracle/oradata/CDB001/redo01_renamed.log        0
  2 /app/oracle/oradata/CDB001/redo02_renamed.log        0
  3 /app/oracle/oradata/CDB001/redo03_renamed.log        0

Renaming tablespaces:

You can rename a permanent or temporary tablespace using the ALTER TABLESPACE RENAME statement. Just remember that you cannot rename SYSTEM or SYSAUX tablespace:

SQL>  SELECT a.con_id, a.name, b.name FROM v$containers a, v$tablespace b WHERE a.con_id = b.con_id ORDER BY 1,3;
?
    CON_ID NAME      NAME
---------- ------------------------------ ------------------------------
  1 CDB$ROOT     SYSAUX
  1 CDB$ROOT     SYSTEM
  1 CDB$ROOT     TEMP
  1 CDB$ROOT     UNDOTBS1
  1 CDB$ROOT     USERS
  2 PDB$SEED     SYSAUX
  2 PDB$SEED     SYSTEM
  2 PDB$SEED     TEMP
  3 PDB001     SYSAUX
  3 PDB001     SYSTEM
  3 PDB001     TEMP
  3 PDB001     USERS
  4 PDB002     SYSAUX
  4 PDB002     SYSTEM
  4 PDB002     TEMP
  4 PDB002     USERS
  5 PDB003     SYSAUX
  5 PDB003     SYSTEM
  5 PDB003     TEMP
  5 PDB003     USERS
?
20 ROWS selected.
?
SQL>  SHOW con_name    
?
CON_NAME
------------------------------
CDB$ROOT
SQL>  ALTER tablespace USERS RENAME TO USERS_CDBROOT;
?
Tablespace altered.
?
SQL>  SELECT a.con_id, a.name, b.name FROM v$containers a, v$tablespace b WHERE a.con_id = b.con_id ORDER BY 1,3;
?
    CON_ID NAME      NAME
---------- ------------------------------ ------------------------------
  1 CDB$ROOT     SYSAUX
  1 CDB$ROOT     SYSTEM
  1 CDB$ROOT     TEMP
  1 CDB$ROOT     UNDOTBS1
  1 CDB$ROOT     USERS_CDBROOT
  2 PDB$SEED     SYSAUX
  2 PDB$SEED     SYSTEM
  2 PDB$SEED     TEMP
  3 PDB001     SYSAUX
  3 PDB001     SYSTEM
  3 PDB001     TEMP
  3 PDB001     USERS
  4 PDB002     SYSAUX
  4 PDB002     SYSTEM
  4 PDB002     TEMP
  4 PDB002     USERS
  5 PDB003     SYSAUX
  5 PDB003     SYSTEM
  5 PDB003     TEMP
  5 PDB003     USERS
?
20 ROWS selected.
?
SQL>  ALTER SESSION SET container=PDB001;
?
SESSION altered.
?
SQL>  ALTER pluggable DATABASE PDB001 OPEN;
?
Pluggable DATABASE altered.
?
SQL>  ALTER tablespace USERS RENAME TO USERS_PDB001;
?
Tablespace altered.
?
SQL>  SELECT a.con_id, a.name, b.name FROM v$containers a, v$tablespace b WHERE a.con_id = b.con_id ORDER BY 1,3;
?
    CON_ID NAME      NAME
---------- ------------------------------ ------------------------------
  3 PDB001     SYSAUX
  3 PDB001     SYSTEM
  3 PDB001     TEMP
  3 PDB001     USERS_PDB001

Renaming datafiles of a single offline tablespace:

While the database is open, put the tablespace offline, rename the datafile at the operating system level, rename the datafile at the database level and finally take the tablespace online again.

SQL>  col file_name format a50                                    
SQL>  SELECT file_name FROM dba_data_files WHERE tablespace_name = 'USERS';
?
FILE_NAME
--------------------------------------------------
/app/oracle/oradata/CDB001/users01.dbf
?
SQL>  ALTER tablespace USERS offline;
?
Tablespace altered.
?
SQL>  host mv /app/oracle/oradata/CDB001/users01.dbf /app/oracle/oradata/CDB001/users01_renamed.dbf
?
SQL>  host ls -l /app/oracle/oradata/CDB001/users01*   
-rw-r-----. 1 oracle oinstall 5251072 Mar 12 16:36 /app/oracle/oradata/CDB001/users01_renamed.dbf
?
SQL>  ALTER tablespace USERS RENAME datafile '/app/oracle/oradata/CDB001/users01.dbf'
  2  TO '/app/oracle/oradata/CDB001/users01_renamed.dbf';
?
Tablespace altered.
?
SQL>  ALTER tablespace USERS online;
?
Tablespace altered.
?
SQL>  SELECT file_name FROM dba_data_files WHERE tablespace_name = 'USERS';
?
FILE_NAME
--------------------------------------------------
/app/oracle/oradata/CDB001/users01_renamed.dbf

To rename datafiles included in multiple tablespaces follow the redo log file renaming procedure described above (alter database rename file …).

Renaming constraints:

You can rename any constraint defined on a table

SQL>  SHOW USER;
USER IS "MARCOV"
?
SQL>  SELECT dbms_metadata.get_ddl('TABLE', 'T1') FROM dual;
?
DBMS_METADATA.GET_DDL('TABLE','T1')
---------------------------------------------------------
?
  CREATE TABLE "MARCOV"."T1"
   ( "A" NUMBER
   ) SEGMENT CREATION IMMEDIATE
?
?
SQL>  ALTER TABLE T1 ADD CONSTRAINT t1_mypk PRIMARY KEY (a);
?
TABLE altered.
?
SQL>  SELECT dbms_metadata.get_ddl('TABLE', 'T1') FROM dual;
?
DBMS_METADATA.GET_DDL('TABLE','T1')
---------------------------------------------------------
?
  CREATE TABLE "MARCOV"."T1"
   ( "A" NUMBER,
  CONSTRAINT "T1_MYPK" PRIMARY KEY ("A")
?
?
SQL>  ALTER TABLE T1 RENAME CONSTRAINT T1_MYPK TO T1_PK; 
?
TABLE altered.
?
SQL>  SELECT dbms_metadata.get_ddl('TABLE', 'T1') FROM dual;
?
DBMS_METADATA.GET_DDL('TABLE','T1')
---------------------------------------------------------
?
  CREATE TABLE "MARCOV"."T1"
   ( "A" NUMBER,
  CONSTRAINT "T1_PK" PRIMARY KEY ("A")

Renaming schema objects (tables, views, sequences, private synonyms, indexes, triggers):

You can rename tables, views, sequences and private synonym using the rename statement.

SQL>  SHOW USER;
USER IS "MARCOV"
?
SQL>  CREATE SEQUENCE T1_MYSEQ;
?
SEQUENCE created.
?
SQL>  RENAME T1_MYSEQ TO T1_S001;
?
TABLE renamed.
?
SQL>  CREATE TABLE mysecondtable (a NUMBER);
?
TABLE created.
?
SQL>  RENAME mysecondtable TO T2;
?
TABLE renamed.
?
SQL>  SELECT dbms_metadata.get_ddl('TABLE', 'T2') FROM dual;
?
DBMS_METADATA.GET_DDL('TABLE','T2')
---------------------------------------------------------
?
  CREATE TABLE "MARCOV"."T2"
   ( "A" NUMBER
   ) SEGMENT CREATION DEFERRED
?
SQL>  CREATE OR REPLACE VIEW T1_MYVIEW AS SELECT * FROM T1 WHERE a   RENAME T1_MYVIEW TO T1_VIEW;
?
TABLE renamed.
?
SQL>  SELECT dbms_metadata.get_ddl('VIEW', 'T1_VIEW') FROM dual;
?
DBMS_METADATA.GET_DDL('VIEW','T1_VIEW')
---------------------------------------------------------
?
  CREATE OR REPLACE FORCE EDITIONABLE VIEW "MARCOV"."T1_VIEW" ("A") AS
  SELECT "A" FROM T1 WHERE a   CREATE public synonym pub_t1 FOR t1;
?
Synonym created.
?
SQL>  CREATE synonym priv_t1 FOR t1;
?
Synonym created.

As you can see it is not possible to rename public synonymns, just the privates.

SQL>  RENAME pub_t1 TO public_t1;
RENAME pub_t1 TO public_t1
*
ERROR at line 1:
ORA-04043: object PUB_T1 does NOT exist
?
?
SQL>  RENAME priv_t1 TO private_t1;
?
TABLE renamed.

Synonym of a renamed object returns instead an error when used:

SQL>  SELECT COUNT(*) FROM private_t1;
?
  COUNT(*)
----------
  1
?
SQL>  RENAME t1 TO t1_renamed;
?
TABLE renamed.
?
SQL>  SELECT COUNT(*) FROM private_t1;
SELECT COUNT(*) FROM private_t1
                     *
ERROR at line 1:
ORA-00980: synonym translation IS no longer valid
?
?
SQL>  RENAME t1_renamed TO t1;
?
TABLE renamed.
?
SQL>  SELECT COUNT(*) FROM private_t1;
?
  COUNT(*)
----------
  1

To rename schema objects such as indexes and triggers you can use the ALTER … RENAME statement

SQL>  SHOW con_name;
?
CON_NAME
------------------------------
PDB001
SQL>  SHOW USER
USER IS "SYS"
SQL>  SELECT index_name FROM dba_indexes WHERE TABLE_NAME = 'T1';
?
INDEX_NAME
----------------------------------------
T1_MYPK
?
SQL>  ALTER INDEX MARCOV.T1_MYPK RENAME TO T1_INDEX_PK;
?
INDEX altered.
?
SQL>  CREATE OR REPLACE TRIGGER marcov.t1_mytrigger 
  2  BEFORE INSERT
  3  ON marcov.t1
  4  FOR each ROW
  5  DECLARE
  6  i NUMBER;
  7  BEGIN 
  8  i := 0;
  9  END;
 10  /
?
TRIGGER created.
?
SQL>  ALTER TRIGGER marcov.t1_mytrigger RENAME TO t1_trigger;
?
TRIGGER altered.
?
SQL>  SELECT owner, trigger_name FROM dba_triggers WHERE trigger_name = 'T1_TRIGGER';
?
OWNER       TRIGGER_NAME
-------------------- ----------------------------------------
MARCOV       T1_TRIGGER

Renaming table columns:

It’s possible to rename existing columns of a table using the ALTER TABLE … RENAME COLUMN statement

SQL>  ALTER TABLE t1 RENAME COLUMN a TO b;
?
TABLE altered.

Renaming table and index partitions (subpartitions):

The same RENAME TO statement could be applied to table or index partitions as in the following examples:

SQL>  ALTER TABLE t1 ADD (a NUMBER);
?
TABLE altered.
?
SQL>  CREATE INDEX T1_index_partitioned ON T1 (a)
  2  global partition BY range (a)
  3  (partition p1 VALUES less than (10),
  4  partition p2 VALUES less than (100),
  5  partition p3 VALUES less than (maxvalue));
?
INDEX created.
?
SQL>  ALTER INDEX T1_index_partitioned RENAME partition p3 TO pmax;
?
INDEX altered.
?
?
SQL>  DROP TABLE t2 purge;
?
TABLE dropped.
?
SQL>  CREATE TABLE T2 (a NUMBER, quarter DATE) partition BY range (quarter) 
  2  (partition Q1_2012 VALUES less than (to_date('01/04/2012','DD/MM/YYYY')),
  3  partition Q2_2012 VALUES less than (to_date('01/07/2012','DD/MM/YYYY')),
  4  partition Q3_2012 VALUES less than (to_date('01/10/2012','DD/MM/YYYY')),
  5  partition Q4_2012 VALUES less than (to_date('01/01/2013','DD/MM/YYYY')),
  6  partition Q1_2013 VALUES less than (to_date('01/04/2013','DD/MM/YYYY')),
  7  partition Q2_2013 VALUES less than (to_date('01/07/2013','DD/MM/YYYY')),
  8  partition Q3_2013 VALUES less than (to_date('01/10/2013','DD/MM/YYYY')),
  9  partition Q4_2013 VALUES less than (to_date('01/01/2014','DD/MM/YYYY')),
 10  partition Q1_2014 VALUES less than (to_date('01/04/2014','DD/MM/YYYY')),
 11  partition Q2_2014 VALUES less than (to_date('01/07/2014','DD/MM/YYYY')),
 12  partition Q3_2014 VALUES less than (to_date('01/10/2014','DD/MM/YYYY')),
 13  partition Q4_2014 VALUES less than (maxvalue));
?
TABLE created.
?
SQL>  ALTER TABLE t2 RENAME partition Q4_2014 TO Q_MAX;
?
TABLE altered.

Restoring and Renaming table from the Recycle Bin:

You have a dropped table, it is still available in the recycle bin and you want to recover it using the FLASHBACK TABLE … TO BEFORE DROP statement. With the clause RENAME TO you can rename the original table name and assign a new one during the recovery process.

SQL>  SHOW USER
USER IS "MARCOV"
SQL>  SELECT * FROM tab;
?
no ROWS selected
?
SQL>  CREATE TABLE T1 (a NUMBER);
?
TABLE created.
?
SQL>  DROP TABLE t1;
?
TABLE dropped.
?
SQL>  CREATE TABLE T1 (a NUMBER);
?
TABLE created.
?
SQL>  SELECT * FROM tab;
?
TNAME      TABTYPE  CLUSTERID
---------------------------------------- ------- ----------
BIN$9IBy6OCMQ0zgRQAAAAAAAQ==$0   TABLE
T1      TABLE
?
SQL>  SHOW recyclebin
ORIGINAL NAME  RECYCLEBIN NAME  OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
T1   BIN$9IBy6OCMQ0zgRQAAAAAAAQ==$0 TABLE      2014-03-13:17:32:48
SQL>  flashback TABLE "BIN$9IBy6OCMQ0zgRQAAAAAAAQ==$0" TO BEFORE DROP RENAME TO T2;
?
Flashback complete.
?
SQL>  SELECT * FROM tab;
?
TNAME      TABTYPE  CLUSTERID
---------------------------------------- ------- ----------
T1      TABLE
T2      TABLE
?
SQL>  SHOW recyclebin
SQL>

An equivalent statement to recover and rename the same table could be: flashback table T1 to before drop rename to T2;
Don’t forget that double quotes are required when dealing with system generated names
such as BIN$9IBy6OCMQ0zgRQAAAAAAAQ==$0.
Dependent objects of a restored table from the recycle bin such as indexes mantains the system generated names, but you can rename them using the ALTER INDEX … RENAME TO statement described above in the “Renaming Schema Objects” section.

Changing the domain in a global database name for a CDB:

It’s possible to modify the domain of a global database name using the ALTER DATABASE RENAME GLOBAL_NAME TO database_name.network_domain_name statement

SQL>  SELECT * FROM global_name;
?
GLOBAL_NAME
------------------------------------------------------
CDB001.MARCOV.COM
?
SQL>  ALTER DATABASE RENAME global_name TO CDB001.IT.MARCOV.COM;
?
DATABASE altered.
?
SQL>  SELECT * FROM global_name;
?
GLOBAL_NAME
------------------------------------------------------
CDB001.IT.MARCOV.COM

Also the domain of each PDBs is affected when the previous statement is applied to the domain name of a CDB.

Renaming a PDB:

For a pluggable database you cannot modify the domain name directly. When you only want to change the name of a specific PDB you can use the ALTER PLUGGABLE DATABASE RENAME GLOBAL_NAME TO statement. The pluggable database must be open in restricted mode.

SQL>  ALTER SESSION SET container=PDB001;
?
SESSION altered.
?
SQL>  SELECT * FROM global_name;
SELECT * FROM global_name
              *
ERROR at line 1:
ORA-01219: DATABASE OR pluggable DATABASE NOT OPEN: queries allowed ON fixed
TABLES OR views ONLY
?
SQL>  ALTER pluggable DATABASE PDB001 OPEN;
?
Pluggable DATABASE altered.
?
SQL>  SELECT * FROM global_name;
?
GLOBAL_NAME
------------------------------------------------------
PDB001.IT.MARCOV.COM
?
SQL>  ALTER pluggable DATABASE RENAME global_name TO PDB001.ROME.IT.MARCOV.COM;
ALTER pluggable DATABASE RENAME global_name TO PDB001.ROME.IT.MARCOV.COM
                                               *
ERROR at line 1:
ORA-65045: pluggable DATABASE NOT IN a restricted mode
?
?
SQL>  ALTER pluggable DATABASE PDB001 close;
?
Pluggable DATABASE altered.
?
SQL>  ALTER pluggable DATABASE PDB001 OPEN restricted;
?
Pluggable DATABASE altered.
?
SQL>  SELECT * FROM global_name;
?
GLOBAL_NAME
------------------------------------------------------
PDB001.IT.MARCOV.COM
?
SQL>  ALTER pluggable DATABASE RENAME global_name TO PDB001.ROME.IT.MARCOV.COM;
ALTER pluggable DATABASE RENAME global_name TO PDB001.ROME.IT.MARCOV.COM
                                               *
ERROR at line 1:
ORA-65042: name IS already used BY an existing container
?
?
SQL>  ALTER pluggable DATABASE RENAME global_name TO PDB001_ROME.IT.MARCOV.COM;
?
Pluggable DATABASE altered.
?
SQL>  SELECT name, open_mode FROM V$PDBS;
?
NAME          OPEN_MODE
------------------------------ ----------
PDB001_ROME         READ WRITE
?
SQL>  SELECT * FROM global_name;
?
GLOBAL_NAME
------------------------------------------------------
PDB001_ROME.IT.MARCOV.COM

That’s all.
oracle_rename

原文地址：转载-How to rename everything on Oracle Database (re, 感谢原作者分享。

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

解释InnoDB缓冲池及其对性能的重要性。Apr 19, 2025 am 12:24 AM

InnoDBBufferPool通过缓存数据和索引页来减少磁盘I/O，提升数据库性能。其工作原理包括：1.数据读取：从BufferPool中读取数据；2.数据写入：修改数据后写入BufferPool并定期刷新到磁盘；3.缓存管理：使用LRU算法管理缓存页；4.预读机制：提前加载相邻数据页。通过调整BufferPool大小和使用多个实例，可以优化数据库性能。

MySQL与其他编程语言：一种比较Apr 19, 2025 am 12:22 AM

MySQL与其他编程语言相比，主要用于存储和管理数据，而其他语言如Python、Java、C 则用于逻辑处理和应用开发。 MySQL以其高性能、可扩展性和跨平台支持着称，适合数据管理需求，而其他语言在各自领域如数据分析、企业应用和系统编程中各有优势。

学习MySQL：新用户的分步指南Apr 19, 2025 am 12:19 AM

MySQL值得学习，因为它是强大的开源数据库管理系统，适用于数据存储、管理和分析。1）MySQL是关系型数据库，使用SQL操作数据，适合结构化数据管理。2）SQL语言是与MySQL交互的关键，支持CRUD操作。3）MySQL的工作原理包括客户端/服务器架构、存储引擎和查询优化器。4）基本用法包括创建数据库和表，高级用法涉及使用JOIN连接表。5）常见错误包括语法错误和权限问题，调试技巧包括检查语法和使用EXPLAIN命令。6）性能优化涉及使用索引、优化SQL语句和定期维护数据库。

MySQL：初学者的基本技能Apr 18, 2025 am 12:24 AM

MySQL适合初学者学习数据库技能。1.安装MySQL服务器和客户端工具。2.理解基本SQL查询，如SELECT。3.掌握数据操作：创建表、插入、更新、删除数据。4.学习高级技巧：子查询和窗口函数。5.调试和优化：检查语法、使用索引、避免SELECT*，并使用LIMIT。

MySQL：结构化数据和关系数据库Apr 18, 2025 am 12:22 AM

MySQL通过表结构和SQL查询高效管理结构化数据，并通过外键实现表间关系。1.创建表时定义数据格式和类型。2.使用外键建立表间关系。3.通过索引和查询优化提高性能。4.定期备份和监控数据库确保数据安全和性能优化。

MySQL：解释的关键功能和功能Apr 18, 2025 am 12:17 AM

MySQL是一个开源的关系型数据库管理系统，广泛应用于Web开发。它的关键特性包括：1.支持多种存储引擎，如InnoDB和MyISAM，适用于不同场景；2.提供主从复制功能，利于负载均衡和数据备份；3.通过查询优化和索引使用提高查询效率。

SQL的目的：与MySQL数据库进行交互Apr 18, 2025 am 12:12 AM

SQL用于与MySQL数据库交互，实现数据的增、删、改、查及数据库设计。1）SQL通过SELECT、INSERT、UPDATE、DELETE语句进行数据操作；2）使用CREATE、ALTER、DROP语句进行数据库设计和管理；3）复杂查询和数据分析通过SQL实现，提升业务决策效率。

初学者的MySQL：开始数据库管理Apr 18, 2025 am 12:10 AM

MySQL的基本操作包括创建数据库、表格，及使用SQL进行数据的CRUD操作。1.创建数据库：CREATEDATABASEmy_first_db;2.创建表格：CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY,titleVARCHAR(100)NOTNULL,authorVARCHAR(100)NOTNULL,published_yearINT);3.插入数据：INSERTINTObooks(title,author,published_year)VA

See all articles