[MySQL]MySQL数据库中如何查询出所有包含指定的一个或者多个字段名(列名)的数据表集合？

[MySQL]MySQL数据库中如何查询出所有包含指定的一个或者多个字段名(列名)的数据表集合？

问题描述

比如当前有几个字段(列)名的集合，需要查询某个MySQL数据库中所有包含的这些字段(列)集合的数据表，在MySQL语句中应该如何实现呢？

方案一

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

方案二

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%wild%';

方案三

SELECT * FROM information_schema.columns WHERE column_name = 'column_name';

方案四

SELECT DISTINCT TABLE_NAME, COLUMN_NAME  
FROM INFORMATION_SCHEMA.COLUMNS  
WHERE column_name LIKE 'employee%'  
AND TABLE_SCHEMA='YourDatabase'

方案五

SELECT DISTINCT TABLE_NAME FROM information_schema.columns WHERE 
TABLE_SCHEMA = 'your_db_name' AND TABLE_NAME NOT IN (SELECT DISTINCT 
TABLE_NAME FROM information_schema.columns WHERE column_name = 
'column_name' AND TABLE_SCHEMA = 'your_db_name');

方案六

SELECT DISTINCT TABLE_NAME, COLUMN_NAME  
FROM INFORMATION_SCHEMA.COLUMNS  
WHERE column_name LIKE '%'  
AND TABLE_SCHEMA='tresbu_lk'