MYSQL查表的字段名称，字段类型，字段长度，字段注释的SQL语句

SELECT  COLUMN_NAME as '列名',COLUMN_COMMENT,DATA_TYPE as '字段类型' ,COLUMN_TYPE as
 '长度加类型' FROM information_schema.`COLUMNS` where TABLE_NAME like 'table_name'

COLUMN_NAME——列名

COLUMN_COMMENT——注释

DATA_TYPE——类型

COLUMN_TYPE——长度加类型