导出数据库里所有的表为一个表格(包括中文描述)
SELECT
t.TABLE_NAME AS '表名',
t.TABLE_COMMENT AS '中文描述',
'查询' AS '操作'
FROM
INFORMATION_SCHEMA.TABLES t
WHERE table_schema = 'test_db_205';
导出数据库里所有的表为一个表格(包括中文描述)
SELECT
t.TABLE_NAME AS '表名',
t.TABLE_COMMENT AS '中文描述',
'查询' AS '操作'
FROM
INFORMATION_SCHEMA.TABLES t
WHERE table_schema = 'test_db_205';