通过 information_schema 来查找
指定库查找
SELECT table_name
FROM information_schema.columns
WHERE table_schema = '库名'
AND column_name = '字段名';
整个实例查找
SELECT table_name
FROM information_schema.columns
WHERE column_name = '字段名';
SELECT table_name
FROM information_schema.columns
WHERE table_schema = '库名'
AND column_name = '字段名';
SELECT table_name
FROM information_schema.columns
WHERE column_name = '字段名';
评论区