SELECT
case when a.ORDINAL_POSITION=1 then a.TABLE_NAME else "" end as "表名",
case when a.ordinal_position=1 then ifnull(b.TABLE_COMMENT,"") else "" end as "表说明",
a.ORDINAL_POSITION as "字段序号",
a.COLUMN_NAME as "字段名",
case when a.EXTRA="auto_increment" then '√'else "" end as "是否自增",
case when a.COLUMN_KEY="PRI" then '是' else "" end as "主键",
a.DATA_TYPE as "类型",
ifnull(a.CHARACTER_MAXIMUM_LENGTH,ifnull(a.NUMERIC_PRECISION,"")) as "长度",
ifnull(NUMERIC_SCALE,"") as "小数位数",
case when a.IS_NULLABLE="YES" then '√'else "" end as "允许空",
ifnull(a.COLUMN_DEFAULT,"") as "默认值",
ifnull(a.COLUMN_COMMENT,"") as "字段说明"
FROM information_schema.COLUMNS a
LEFT JOIN INFORMATION_SCHEMA.TABLES b ON b.TABLE_SCHEMA = a.TABLE_SCHEMA AND b.TABLE_NAME = a.TABLE_NAME
WHERE a.TABLE_SCHEMA NOT IN ("sys","performance_schema","information_schema","mysql")
AND a.TABLE_SCHEMA = DATABASE()
ORDER BY a.TABLE_NAME,a.ORDINAL_POSITION
