1. 查询所有的表
SELECT
CREATE_TIME createTime,
UPDATE_TIME updateTime,
TABLE_ROWS dataRows,
TABLE_NAME name,
TABLE_COMMENT remark
FROM
information_schema.TABLES WHERE TABLE_SCHEMA = '数据库名'
2.查询表中的字段(注释,类型等)
SELECT
COLUMN_NAME name,
CASE
COLUMN_key
WHEN 'PRI' THEN
1 ELSE 0
END isKey,
DATA_TYPE type,
COLUMN_COMMENT remark
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = '数据库名' AND TABLE_NAME = "表名"