例如:
查询cpms_land库中包含ORG_CODE的表
select TABLE_NAME from information_schema.`COLUMNS` where COLUMN_NAME='ORG_CODE' and TABLE_SCHEMA='cpms_land'
例如:
查询cpms_land库中包含ORG_CODE的表
select TABLE_NAME from information_schema.`COLUMNS` where COLUMN_NAME='ORG_CODE' and TABLE_SCHEMA='cpms_land'