7.21 SHOW句法 (得到表,列等的信息) SHOW DATABASES [LIKE wild] or SHOW TABLES [FROM db_name] [LIKE wild] or SHOW COLUMNS FROM tbl_name [FROM db_name] [LIKE wild] or SHOW INDEX FROM tbl_name [FROM db_name] or SHOW STATUS or SHOW VARIABLES [LIKE wild] or SHOW [FULL] PROCESSLIST or SHOW TABLE STATUS [FROM db_name] [LIKE wild] or SHOW GRANTS FOR user
use information_schema; select * from SCHEMATA现在在mysql中,应该一个数据库就对应一个SCHEMATA
show databases; 简单方便明了!
SHOW DATABASES ; or SHOW SCHEMAS;[align=center]====思想重于技巧==== [/align]
SHOW DATABASES [LIKE wild]
or SHOW TABLES [FROM db_name] [LIKE wild]
or SHOW COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]
or SHOW INDEX FROM tbl_name [FROM db_name]
or SHOW STATUS
or SHOW VARIABLES [LIKE wild]
or SHOW [FULL] PROCESSLIST
or SHOW TABLE STATUS [FROM db_name] [LIKE wild]
or SHOW GRANTS FOR user
select * from SCHEMATA现在在mysql中,应该一个数据库就对应一个SCHEMATA
简单方便明了!
or
SHOW SCHEMAS;[align=center]==== 思想重于技巧 ====
[/align]
或
SHOW SCHEMAS;