例如,我要查找goods
库和base
库中,哪些表中含有name
字段,则sql如下:
SELECT DISTINCT(table_name), TABLE_SCHEMA FROM information_schema.columns
WHERE column_name like '%name%'
AND TABLE_SCHEMA in ('goods', 'base');
例如,我要查找goods
库和base
库中,哪些表中含有name
字段,则sql如下:
SELECT DISTINCT(table_name), TABLE_SCHEMA FROM information_schema.columns
WHERE column_name like '%name%'
AND TABLE_SCHEMA in ('goods', 'base');