MySql获取某个字段存在于哪个表的sql语句

select table_schema,table_name from information_schema.`columns` where column_name = 'col1'

col1为子段名。