查询库里所有的表与表字段信息

查询库里所有的表

SELECT
    table_name
FROM
    information_schema. TABLES
WHERE
    table_schema = '数据库名称'
ORDER BY
    table_name ASC;

查询表字段信息

SELECT
    column_name,
    column_comment,
    data_type
FROM
    information_schema. COLUMNS
WHERE
    table_name = '查询表名称'
AND table_schema = '数据库名称'