mysql查询表结构.txt

SELECT 
 a.TABLE_SCHEMA 数据库,
 a.TABLE_NAME 表名称,
 b.TABLE_COMMENT 表说明,
 a.ORDINAL_POSITION 序号,
 a.COLUMN_NAME 字段名称,
 CASE
WHEN a.COLUMN_KEY = 'PRI' THEN 
 '√'
ELSE 
 ''
END 主键, 
 CASE 
WHEN a.EXTRA = 'auto_increment' THEN 
 '√'
ELSE 
 ''
END 标识, 
 a.COLUMN_TYPE 类型, 
 IFNULL( 
 a.NUMERIC_PRECISION,
 a.CHARACTER_MAXIMUM_LENGTH
) 长度, 
 IFNULL(a.NUMERIC_SCALE, 0) 精度, 
 CASE 
WHEN a.IS_NULLABLE = 'NO' THEN 
 ''
ELSE 
 '√'
END 允许空,