MySql获取表的字段名称、字段注解、字段类型、字段长度

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

posted @ 2015-05-05 17:50  yubinfeng  阅读(1255)  评论(0)  编辑  收藏  举报