SELECT TABLE_NAME as '表名', COLUMN_NAME as '列名',COLUMN_COMMENT,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型' FROM information_schema.`COLUMNS` where TABLE_SCHEMA='smarthos_ty' order by TABLE_NAME,COLUMN_NAME
1500字范文,内容丰富有趣,写作好帮手!
时间:2023-03-27 16:25:08
SELECT TABLE_NAME as '表名', COLUMN_NAME as '列名',COLUMN_COMMENT,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型' FROM information_schema.`COLUMNS` where TABLE_SCHEMA='smarthos_ty' order by TABLE_NAME,COLUMN_NAME
mysql 查询该字段长度(如何使用mysql查询字段长度) mysql 检查数据库版本
2019-10-18