SELECT
table_schema AS 'Database',
table_name AS 'Table'
FROM
information_schema.tables
ORDER BY table_schema,
table_name ;
MySQL:同时获取所有的数据库及其所有的表格
![](https://img-home.csdnimg.cn/images/20240711042549.png)
SELECT
table_schema AS 'Database',
table_name AS 'Table'
FROM
information_schema.tables
ORDER BY table_schema,
table_name ;