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:字段名;

Logo

汇聚全球AI编程工具,助力开发者即刻编程。

更多推荐