查找 数据库中包含某一字段的所有表的表名的mysql语句

select table_name from information_schema.columns where column_name = "column_id" AND `TABLE_SCHEMA` = "database_name" ;