mysql 查看某个字段(列名)在哪个表中
·
MySQL 中,查找某个字段(列名)存在于哪些表中,可通过查询 information_schema.COLUMNS 视图实现。
SELECT
TABLE_SCHEMA AS database_name,
TABLE_NAME AS table_name,
COLUMN_NAME AS column_name,
DATA_TYPE AS data_type
FROM information_schema.COLUMNS
WHERE COLUMN_NAME LIKE '%Currency%'
AND TABLE_SCHEMA NOT IN ('information_schema', 'mysql', 'performance_schema', 'sys');
WHERE COLUMN_NAME = ‘your_column_name’
TABLE_SCHEMA:数据库名;
TABLE_NAME:表名;
COLUMN_NAME:字段名;
更多推荐




所有评论(0)