查看某个库中哪些表存在对应的某个字段
SELECT
*
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '数据库名称'
AND COLUMN_NAME = '字段名称'
查看某个库中哪些表存在对应的某个字段
SELECT
*
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '数据库名称'
AND COLUMN_NAME = '字段名称'