SELECT COLUMN_NAME as '列名',COLUMN_COMMENT,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型' FROM information_schema.`COLUMNS` where TABLE_NAME like 'crcustomer'
MySql获取表的字段名称、字段注解、字段类型、字段长度
最新推荐文章于 2024-07-09 14:38:59 发布
SELECT COLUMN_NAME as '列名',COLUMN_COMMENT,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型' FROM information_schema.`COLUMNS` where TABLE_NAME like 'crcustomer'