select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like '%store_id%' AND DATA_TYPE = 'VARCHAR'
查询db里包含store_id字段的所有表 条件为字段类型为varchar
select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like '%store_id%' AND DATA_TYPE = 'VARCHAR'
查询db里包含store_id字段的所有表 条件为字段类型为varchar