mysql查询所有的表信息和查询存在某个字段的表

查询当前数据库所有表

select table_name from information_schema.tables where table_schema=‘数据库名’ and table_type=‘base table’

查询存在某个字段的表

SELECT DISTINCT TABLE_NAME FROM information_schema.COLUMNS WHERE COLUMN_NAME = ‘列名’ AND TABLE_SCHEMA=‘数据库名’

使用group_concat 格式化查出来的值:

select group_concat(concat('"',table_name,'"')) from information_schema.tables where table_schema='tiger2';

SELECT DISTINCT group_concat(concat('"',table_name,'"'))  FROM information_schema.COLUMNS WHERE COLUMN_NAME = 'book_id' AND TABLE_SCHEMA='tiger2';