SELECT COLUMN_NAME as '列名' ,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型' FROM information_schema.`COLUMNS` where TABLE_SCHEMA like 'MONITOR' and TABLE_NAME like 'liudi';
MySQL中查询已定义字段的类型和长度命令
最新推荐文章于 2023-08-09 14:36:05 发布