SELECT
COLUMN_COMMENT 描述,
COLUMN_NAME 字段,
COLUMN_TYPE 类型,
DATA_TYPE 字段类型,
CHARACTER_MAXIMUM_LENGTH 长度,
IS_NULLABLE 是否为空,
COLUMN_DEFAULT 默认值
FROM
INFORMATION_SCHEMA.COLUMNS
where
table_schema ='库名'
AND
table_name = '表名'
或
table_name in (表,表)