查询表名信息
SELECT
t.TABLE_NAME AS 表名,
t.TABLE_COMMENT AS 表注释,
GROUP_CONCAT(c.COLUMN_NAME) AS 主键字段
FROM
information_schema.TABLES t
LEFT JOIN
information_schema.KEY_COLUMN_USAGE c
ON
t.TABLE_SCHEMA = c.TABLE_SCHEMA
AND t.TABLE_NAME = c.TABLE_NAME
AND c.CONSTRAINT_NAME = 'PRIMARY'
WHERE
t.TABLE_SCHEMA = 'line'
GROUP BY
t.TABLE_NAME, t.TABLE_COMMENT
ORDER BY
t.TABLE_NAME;
查询表字段信息
SELECT
TABLE_NAME 表名,
COLUMN_NAME 字段名称,
COLUMN_COMMENT 字段中文名,
COLUMN_COMMENT 字段描述
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'line'
ORDER BY
TABLE_NAME,
ORDINAL_POSITION;
