mysql查询字段在哪个表

查询web3.xin字段在哪个数据库哪个表

SELECT
TABLE_SCHEMA,
TABLE_NAME
FROM
information_schema.`COLUMNS`
WHERE
COLUMN_NAME = 'web3.xin'

查询web3.xin字段在school数据库的哪个表

SELECT
TABLE_SCHEMA '数据库名',
TABLE_NAME '表名'
FROM
information_schema.`COLUMNS`
WHERE
COLUMN_NAME = 'web3.xin' and TABLE_SCHEMA='school'