select * from information_schema.`COLUMNS` where TABLE_SCHEMA='数据库名' and (COLUMN_TYPE='字段类型');
MySQL数据库根据字段类型查询字段信息
最新推荐文章于 2024-01-16 16:35:39 发布
select * from information_schema.`COLUMNS` where TABLE_SCHEMA='数据库名' and (COLUMN_TYPE='字段类型');