MySQL数据字典

 

MySQL数据字典

MySQL中的数据字典用于代替原来的show命令。

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> show tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS 
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY 
| COLUMNS 
| COLUMN_PRIVILEGES 
| KEY_COLUMN_USAGE
| PROFILING 
| ROUTINES 
| SCHEMATA 
| SCHEMA_PRIVILEGES 
| STATISTICS 
| TABLES 
| TABLE_CONSTRAINTS
| TABLE_PRIVILEGES 
| TRIGGERS 
| USER_PRIVILEGES 
| VIEWS 
+---------------------------------------+
17 rows in set (0.00 sec)