56,675
社区成员
发帖
与我相关
我的任务
分享
SELECT table_name, table_type, engine FROM information_schema.tables
SELECT SCHEMA_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
SELECT table_name, table_type, engine
FROM information_schema.tables
mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql |
| test |
| tmp |
+----------+
SELECT SCHEMA_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
mysql> SELECT table_name, table_type, engine
-> FROM information_schema.tables
mysql> SHOW TABLES;
+---------------------+
| Tables in menagerie |
+---------------------+
| pet |
+---------------------+
mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql |
| test |
| tmp |
+----------+