- 数据库
- 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'
