mysql提取表信息sql

SELECT

COLUMN_COMMENT 中文名,
COLUMN_NAME 英文名,
DATA_TYPE 字段类型,
CASE DATA_TYPE
WHEN "int" THEN "整型"
WHEN "varchar" then "字符串"
WHEN "datetime" then "日期时间"
WHEN "smallint" then "短整型"
WHEN "date" then "日期"
WHEN "decimal" then "小数"
WHEN "tinyint" then "微整型"
WHEN "bigint" then "长整型"
WHEN "mediumtext" then "文本"
ELSE
DATA_TYPE
END ,
CHARACTER_MAXIMUM_LENGTH 数据长度,
COLUMN_TYPE 字段描述,
null 枚举说明,
CASE IS_NULLABLE
WHEN "NO" THEN "否"
WHEN "YES" then "是"
ELSE
DATA_TYPE
END

FROM information_schema.COLUMNS WHERE
TABLE_NAME IN (
'----表名---') AND
TABLE_SCHEMA = '----数据库名---';