mysql查询某个字段在哪些表中

查询sql如下查看某个库中哪些表存在对应的某个字段select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like '%字段名%' and table_schema = '库名';查看某个库中某个表中是否存在对应的某个字段select * from INFORMATION_SCHEMA.columns where COLUMN_NAME

liuqun0319

3757人浏览 · 2021-09-03 15:14:57

liuqun0319 · 2021-09-03 15:14:57 发布

查询sql如下


查看某个库中哪些表存在对应的某个字段
select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like '%字段名%' and table_schema = '库名';


查看某个库中某个表中是否存在对应的某个字段
select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like '%字段名%' and table_schema = '库名' and table_name='表名';