Bo's Oracle Station › 博客首页 ›Oracle技术› Oracle云、Linux、MySQL和Java › 查看内容

【博客文章2026】MySQL 9.x数据库管理技巧---给初学者的建议5：获取数据字典信息

2026-3-16 16:53| 发布者: admin| 查看: 464| 评论: 0|原作者: Bo Tang

摘要: 通过动手实践，掌握从 MySQL 9.x 数据库中获取常用元数据的多种方法。

Author: Bo Tang

1. 查看数据库/Schema信息：

登录Mysql客户端，执行：

[root@station95 ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 39

Server version: 9.6.0 MySQL Community Server - GPL

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from information_schema.schemata where schema_name='world_y'\G

*************************** 1. row ***************************

CATALOG_NAME: def

SCHEMA_NAME: world_y

DEFAULT_CHARACTER_SET_NAME: utf8mb4

DEFAULT_COLLATION_NAME: utf8mb4_0900_ai_ci

SQL_PATH: NULL

DEFAULT_ENCRYPTION: NO

1 row in set (0.002 sec)

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| world_y |

+--------------------+

5 rows in set (0.002 sec)

2. 查看某个数据库中的所有表的信息：

登录Mysql客户端，执行：

mysql> use information_schema;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select table_name, engine from tables where table_schema='world_y';

+-----------------+--------+

| TABLE_NAME | ENGINE |

+-----------------+--------+

| city | InnoDB |

| country | InnoDB |

| countryinfo | InnoDB |

| countrylanguage | InnoDB |

+-----------------+--------+

4 rows in set (0.003 sec)

mysql> use world_y;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+-------------------+

| Tables_in_world_y |

+-------------------+

| city |

| country |

| countryinfo |

| countrylanguage |

+-------------------+

4 rows in set (0.003 sec)

mysql> show tables like 'cit%';

+--------------------------+

| Tables_in_world_y (cit%) |

+--------------------------+

| city |

+--------------------------+

1 row in set (0.003 sec)

查看某个表的数据长度：

mysql> select table_name, data_length from tables where table_schema='world_y' and table_name='city';

+------------+-------------+

| TABLE_NAME | DATA_LENGTH |

+------------+-------------+

| city | 524288 |

+------------+-------------+

1 row in set (0.008 sec)

3. 以数据库/Schema和存储引擎作为分类依据，查看表信息：

登录Mysql客户端，执行：

mysql> select table_schema,engine, count(*) from tables group by table_schema,engine;

+--------------------+--------------------+----------+

| TABLE_SCHEMA | ENGINE | count(*) |

+--------------------+--------------------+----------+

| information_schema | NULL | 84 |

| mysql | InnoDB | 36 |

| mysql | CSV | 2 |

| performance_schema | PERFORMANCE_SCHEMA | 117 |

| sys | NULL | 100 |

| sys | InnoDB | 1 |

| world_y | InnoDB | 4 |

+--------------------+--------------------+----------+

7 rows in set (0.020 sec)

4. 获取列级信息：

为了查看某个数据库中，所有char和varchar列的总数，登录Mysql客户端，执行：

mysql> select data_type,count(*) from columns where table_schema='world_y' and data_type in ('char','varchar') group by data_type;

+-----------+----------+

| DATA_TYPE | count(*) |

+-----------+----------+

| char | 8 |

+-----------+----------+

1 row in set (0.003 sec)

注意data_type in ('char','varchar')是小写。

列出某个表所有列的信息：

mysql> use world_y;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show full columns from city\G

*************************** 1. row ***************************

Field: ID

Type: int

Collation: NULL

Null: NO

Key: PRI

Default: NULL

Extra: auto_increment

Privileges: select,insert,update,references

Comment:

*************************** 2. row ***************************

Field: Name

Type: char(35)

Collation: utf8mb4_0900_ai_ci

Null: NO

Key:

Default:

Extra:

Privileges: select,insert,update,references

Comment:

*************************** 3. row ***************************

Field: CountryCode

Type: char(3)

Collation: utf8mb4_0900_ai_ci

Null: NO

Key:

Default:

Extra:

Privileges: select,insert,update,references

Comment:

*************************** 4. row ***************************

Field: District

Type: char(20)

Collation: utf8mb4_0900_ai_ci

Null: NO

Key:

Default:

Extra:

Privileges: select,insert,update,references

Comment:

*************************** 5. row ***************************

Field: Info

Type: json

Collation: NULL

Null: YES

Key:

Default: NULL

Extra:

Privileges: select,insert,update,references

Comment:

5 rows in set (0.003 sec)

mysql> desc city;

+-------------+----------+------+-----+---------+----------------+

+-------------+----------+------+-----+---------+----------------+

| ID | int | NO | PRI | NULL | auto_increment |

+-------------+----------+------+-----+---------+----------------+

5 rows in set (0.004 sec)

5. 查看某个表的索引信息：

登录Mysql客户端，执行：

mysql> show index from city\G

*************************** 1. row ***************************

Table: city

Non_unique: 0

Key_name: PRIMARY

Seq_in_index: 1

Column_name: ID

Collation: A

Cardinality: 4079

Sub_part: NULL

Packed: NULL

Null:

Index_type: BTREE

Comment:

Index_comment:

Visible: YES

Expression: NULL

1 row in set (0.004 sec)

登录Mysql客户端，执行：

mysql> use information_schema;

Database changed

mysql> select * from TABLE_CONSTRAINTS where table_name='city';

+--------------------+-------------------+-----------------+--------------+------------+-----------------+----------+

+--------------------+-------------------+-----------------+--------------+------------+-----------------+----------+

+--------------------+-------------------+-----------------+--------------+------------+-----------------+----------+

1 row in set (0.002 sec)

mysql> select * from statistics where table_name='city';

+---------------+--------------+------------+------------+--------------+------------+--------------+-------------+-----------+-------------+----------+--------+----------+------------+---------+---------------+------------+------------+

| def | world_y | city | 0 | world_y | PRIMARY | 1 | ID | A | 4079 | NULL | NULL | | BTREE | | | YES | NULL |

1 row in set (0.003 sec)

6. 显示可用的字符集：

登录Mysql客户端，执行：

mysql> show character set;

+----------+---------------------------------+---------------------+--------+

+----------+---------------------------------+---------------------+--------+

| big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 |

| cp1250 | Windows Central European | cp1250_general_ci | 1 |

| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |

| cp1256 | Windows Arabic | cp1256_general_ci | 1 |

| cp1257 | Windows Baltic | cp1257_general_ci | 1 |

| cp850 | DOS West European | cp850_general_ci | 1 |

| cp852 | DOS Central European | cp852_general_ci | 1 |

| cp866 | DOS Russian | cp866_general_ci | 1 |

| cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 |

| dec8 | DEC West European | dec8_swedish_ci | 1 |

| gb18030 | China National Standard GB18030 | gb18030_chinese_ci | 4 |

| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 |

| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 |

| hp8 | HP West European | hp8_english_ci | 1 |

| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |

| tis620 | TIS620 Thai | tis620_thai_ci | 1 |

| ucs2 | UCS-2 Unicode | ucs2_general_ci | 2 |

| utf16 | UTF-16 Unicode | utf16_general_ci | 4 |

| utf32 | UTF-32 Unicode | utf32_general_ci | 4 |

+----------+---------------------------------+---------------------+--------+

41 rows in set (0.002 sec)

7. 查看排序规则：

登录Mysql客户端，执行：

mysql> show collation;

+-----------------------------+----------+-----+---------+----------+---------+---------------+

+-----------------------------+----------+-----+---------+----------+---------+---------------+

| armscii8_bin | armscii8 | 64 | | Yes | 1 | PAD SPACE |

| armscii8_general_ci | armscii8 | 32 | Yes | Yes | 1 | PAD SPACE |

| ascii_bin | ascii | 65 | | Yes | 1 | PAD SPACE |

| ascii_general_ci | ascii | 11 | Yes | Yes | 1 | PAD SPACE |

| big5_bin | big5 | 84 | | Yes | 1 | PAD SPACE |

| big5_chinese_ci | big5 | 1 | Yes | Yes | 1 | PAD SPACE |

| binary | binary | 63 | Yes | Yes | 1 | NO PAD |

| cp1250_bin | cp1250 | 66 | | Yes | 1 | PAD SPACE |

| cp1250_croatian_ci | cp1250 | 44 | | Yes | 1 | PAD SPACE |

| cp1250_czech_cs | cp1250 | 34 | | Yes | 2 | PAD SPACE |

| cp1250_general_ci | cp1250 | 26 | Yes | Yes | 1 | PAD SPACE |

| cp1250_polish_ci | cp1250 | 99 | | Yes | 1 | PAD SPACE |

| cp1251_bin | cp1251 | 50 | | Yes | 1 | PAD SPACE |

| cp1251_bulgarian_ci | cp1251 | 14 | | Yes | 1 | PAD SPACE |

......

| utf8mb4_sv_0900_ai_ci | utf8mb4 | 264 | | Yes | 0 | NO PAD |

| utf8mb4_sv_0900_as_cs | utf8mb4 | 287 | | Yes | 0 | NO PAD |

| utf8mb4_swedish_ci | utf8mb4 | 232 | | Yes | 8 | PAD SPACE |

| utf8mb4_tr_0900_ai_ci | utf8mb4 | 265 | | Yes | 0 | NO PAD |

| utf8mb4_tr_0900_as_cs | utf8mb4 | 288 | | Yes | 0 | NO PAD |

| utf8mb4_turkish_ci | utf8mb4 | 233 | | Yes | 8 | PAD SPACE |

| utf8mb4_unicode_520_ci | utf8mb4 | 246 | | Yes | 8 | PAD SPACE |

| utf8mb4_unicode_ci | utf8mb4 | 224 | | Yes | 8 | PAD SPACE |

| utf8mb4_vietnamese_ci | utf8mb4 | 247 | | Yes | 8 | PAD SPACE |

| utf8mb4_vi_0900_ai_ci | utf8mb4 | 277 | | Yes | 0 | NO PAD |

| utf8mb4_vi_0900_as_cs | utf8mb4 | 300 | | Yes | 0 | NO PAD |

| utf8mb4_zh_0900_as_cs | utf8mb4 | 308 | | Yes | 0 | NO PAD |

+-----------------------------+----------+-----+---------+----------+---------+---------------+

286 rows in set (0.009 sec)

8. 查看DDL语句：

登录Mysql客户端，执行：

mysql> use world_y;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql>

mysql> show create table city\G;

*************************** 1. row ***************************

Table: city

Create Table: CREATE TABLE `city` (

`ID` int NOT NULL AUTO_INCREMENT,

`Name` char(35) NOT NULL DEFAULT '',

`CountryCode` char(3) NOT NULL DEFAULT '',

`District` char(20) NOT NULL DEFAULT '',

`Info` json DEFAULT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=4080 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

1 row in set (0.001 sec)

9. 查看用户信息：

登录Mysql客户端，执行：

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select host, user from user ;

+-----------+------------------+

| host | user |

+-----------+------------------+

| localhost | mysql.infoschema |

| localhost | mysql.session |

| localhost | mysql.sys |

| localhost | root |

+-----------+------------------+

4 rows in set (0.001 sec)

mysql> show grants for root@localhost;

+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Grants for root@localhost |

+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER,

CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE,

CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION |

| GRANT ALLOW_NONEXISTENT_DEFINER,APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,

BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,CREATE_SPATIAL_REFERENCE_SYSTEM,

ENCRYPTION_KEY_ADMIN,

FIREWALL_EXEMPT,

FLUSH_OPTIMIZER_COSTS,FLUSH_PRIVILEGES,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,

GROUP_REPLICATION_STREAM,

INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,OPTIMIZE_LOCAL_TABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,

REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,

SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_ANY_DEFINER,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,

TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,TRANSACTION_GTID_TAG,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION |

| GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION |

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

3 rows in set (0.001 sec)

授权信息比较长，更合适的展示方法时使用“\G”方式显示：

mysql> show grants for root@localhost\G

*************************** 1. row ***************************

Grants for root@localhost: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES,

INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT,

CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE,

DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION

*************************** 2. row ***************************

Grants for root@localhost: GRANT ALLOW_NONEXISTENT_DEFINER,APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,

AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,

BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,CREATE_SPATIAL_REFERENCE_SYSTEM,

ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_PRIVILEGES,FLUSH_STATUS,FLUSH_TABLES,

FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,

INNODB_REDO_LOG_ENABLE,OPTIMIZE_LOCAL_TABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,

REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,

SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_ANY_DEFINER,

SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,TRANSACTION_GTID_TAG,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION

*************************** 3. row ***************************

Grants for root@localhost: GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION

3 rows in set (0.001 sec)

10. 查看存储引擎的性能统计信息：

性能信息也是数据字典信息的一部分：

mysql> SHOW ENGINES;

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |

| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |

| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |

| MyISAM | YES | MyISAM storage engine | NO | NO | NO |

| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |

| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |

| CSV | YES | CSV storage engine | NO | NO | NO |

| ARCHIVE | YES | Archive storage engine | NO | NO | NO |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

11 rows in set (0.001 sec)

mysql> show engine innodb status\G

*************************** 1. row ***************************

Type: InnoDB

Name:

Status:

=====================================

2026-03-22 01:00:26 140121982605056 INNODB MONITOR OUTPUT

=====================================

Per second averages calculated from the last 42 seconds

-----------------

BACKGROUND THREAD

-----------------

srv_master_thread loops: 60 srv_active, 0 srv_shutdown, 1021193 srv_idle

srv_master_thread log flush and writes: 0

----------

SEMAPHORES

----------

OS WAIT ARRAY INFO: reservation count 88

OS WAIT ARRAY INFO: signal count 80

RW-shared spins 0, rounds 0, OS waits 0

RW-excl spins 0, rounds 0, OS waits 0

RW-sx spins 0, rounds 0, OS waits 0

Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx

------------

TRANSACTIONS

------------

Trx id counter 3617

Purge done for trx's n:o < 3516 undo n:o < 0 state: running but idle

History list length 0

LIST OF TRANSACTIONS FOR EACH SESSION:

---TRANSACTION 421597970349272, not started

0 lock struct(s), heap size 1128, 0 row lock(s)

---TRANSACTION 421597970348464, not started

0 lock struct(s), heap size 1128, 0 row lock(s)

---TRANSACTION 421597970347656, not started

0 lock struct(s), heap size 1128, 0 row lock(s)

--------

FILE I/O

--------

I/O thread 0 state: waiting for completed aio requests (insert buffer thread)

I/O thread 1 state: waiting for completed aio requests (read thread)

I/O thread 2 state: waiting for completed aio requests (read thread)

I/O thread 3 state: waiting for completed aio requests (read thread)

I/O thread 4 state: waiting for completed aio requests (read thread)

I/O thread 5 state: waiting for completed aio requests (write thread)

I/O thread 6 state: waiting for completed aio requests (write thread)

I/O thread 7 state: waiting for completed aio requests (write thread)

I/O thread 8 state: waiting for completed aio requests (write thread)

Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,

ibuf aio reads:

Pending flushes (fsync) log: 0; buffer pool: 0

1075 OS file reads, 3866 OS file writes, 1145 OS fsyncs

0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s

-------------------------------------

INSERT BUFFER AND ADAPTIVE HASH INDEX

-------------------------------------

Ibuf: size 1, free list len 0, seg size 2, 0 merges

merged operations:

insert 0, delete mark 0, delete 0

discarded operations:

insert 0, delete mark 0, delete 0

Hash table size 34679, node heap has 0 buffer(s)

0.00 hash searches/s, 0.00 non-hash searches/s

---

LOG

---

Log capacity 104857600

Log capacity used 104857600

Log sequence number 25673643

Log buffer assigned up to 25673643

Log buffer completed up to 25673643

Log written up to 25673643

Log flushed up to 25673643

Added dirty pages up to 25673643

Pages flushed up to 25673643

Last checkpoint at 25673643

Log minimum file id is 6

Log maximum file id is 7

1375 log i/o's done, 0.00 log i/o's/second

----------------------

BUFFER POOL AND MEMORY

----------------------

Total large memory allocated 0

Dictionary memory allocated 1013092

Buffer pool size 8192

Free buffers 6623

Database pages 1569

Old database pages 559

Modified db pages 0

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 1256, not young 4486

0.00 youngs/s, 0.00 non-youngs/s

Pages read 1042, created 547, written 2082

0.00 reads/s, 0.00 creates/s, 0.00 writes/s

No buffer pool page gets since the last printout

Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s

LRU len: 1569, unzip_LRU len: 0

I/O sum[0]:cur[0], unzip sum[0]:cur[0]

--------------

ROW OPERATIONS

--------------

0 queries inside InnoDB, 0 queries in queue

0 read views open inside InnoDB

Process ID=180124, Main thread ID=140122385258240 , state=sleeping

Number of rows inserted 22258, updated 0, deleted 0, read 1094

0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

Number of system rows inserted 493, updated 727, deleted 356, read 22637

0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

----------------------------

END OF INNODB MONITOR OUTPUT

============================

1 row in set (0.009 sec)

11. 使用mysqlshow查看元数据：

列出所有的数据库：

[root@station95 ~]# mysqlshow -u root -p

Enter password:

+--------------------+

| Databases |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| world_y |

+--------------------+

列出某个数据库的所有表：

[root@station95 ~]# mysqlshow world_y -u root -p

Enter password:

Database: world_y

+-----------------+

| Tables |

+-----------------+

| city |

| country |

| countryinfo |

| countrylanguage |

+-----------------+

列出某个数据库的某个表的所有列：

[root@station95 ~]# mysqlshow world_y countrylanguage -u root -p

Enter password:

Database: world_y Table: countrylanguage

+-------------+---------------+--------------------+------+-----+---------+-------+---------------------------------+---------+

+-------------+---------------+--------------------+------+-----+---------+-------+---------------------------------+---------+

+-------------+---------------+--------------------+------+-----+---------+-------+---------------------------------+---------+

路过

雷人

握手

鲜花

鸡蛋

收藏邀请

上一篇：【博客文章2026】MySQL 9.x数据库管理技巧---给初学者的建议4：在线帮助系统、mysqladmin和mysql-workbench下一篇：【博客文章2026】MySQL 9.x数据库管理技巧6：事务隔离和锁

【博客文章2026】MySQL 9.x数据库管理技巧---给初学者的建议5：获取数据字典信息

相关分类