不弄用SCHEMAS做字段名
mysql使用下列语句可以查询所有数据库
SHOW DATABASES;
SHOW SCHEMAS;
其他的SHOW用法:
SHOW TABLES [FROM db_name]
or SHOW COLUMNS FROM tbl_name [FROM db_name]
or SHOW INDEX FROM tbl_name [FROM db_name]
or SHOW STATUS
or SHOW VARIABLES
or SHOW [FULL] PROCESSLIST
or SHOW TABLE STATUS [FROM db_name]
or SHOW GRANTS FOR user
mysql使用下列语句可以查询所有数据库
SHOW DATABASES;
SHOW SCHEMAS;
其他的SHOW用法:
SHOW TABLES [FROM db_name]
or SHOW COLUMNS FROM tbl_name [FROM db_name]
or SHOW INDEX FROM tbl_name [FROM db_name]
or SHOW STATUS
or SHOW VARIABLES
or SHOW [FULL] PROCESSLIST
or SHOW TABLE STATUS [FROM db_name]
or SHOW GRANTS FOR user