查询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='表名';