---查询所有的表名和备注
SELECT
TABLE_NAME,
TABLE_COMMENT
FROM
information_schema. TABLES
WHERE
TABLE_SCHEMA = 'i_wlp_trans';
------查询所有表字段的内容及备注
SELECT
TABLE_SCHEMA AS '数据库名',
TABLE_NAME AS '表名',
COLUMN_NAME AS '列名',
COLUMN_TYPE AS '类型',
COLUMN_DEFAULT AS '默认值',
IS_NULLABLE AS '允许为空',
DATA_TYPE AS '数据类型',
CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',
NUMERIC_PRECISION AS '数字精度',
NUMERIC_SCALE AS '小数位数',
COLUMN_COMMENT AS '字段说明'
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'it_wp_trs'
