----------------查询fans字段在哪个数据库哪个表-----------------------------
SELECT
TABLE_SCHEMA,
TABLE_NAME
FROM
information_schema.`COLUMNS`
WHERE
SELECT
TABLE_SCHEMA '数据库名',
TABLE_NAME '表名'
FROM
information_schema.`COLUMNS`
WHERE
COLUMN_NAME = 'fans' and TABLE_SCHEMA='wljdb'
SELECT
TABLE_SCHEMA,
TABLE_NAME
FROM
information_schema.`COLUMNS`
WHERE
COLUMN_NAME = 'fans'
SELECT
TABLE_SCHEMA '数据库名',
TABLE_NAME '表名'
FROM
information_schema.`COLUMNS`
WHERE
COLUMN_NAME = 'fans' and TABLE_SCHEMA='wljdb'