MySQL查询某字段在哪些表中

https://blog.csdn.net/qq_45722267/article/details/126350980?spm=1001.2101.3001.6650.3&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-3-126350980-blog-123066515.235%5Ev31%5Epc_relevant_default_base3&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-3-126350980-blog-123066515.235%5Ev31%5Epc_relevant_default_base3&utm_relevant_index=6

需要使用的的表：INFORMATION_SCHEMA.COLUMNS

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name = '字段名'

INFORMATION_SCHEMA.COLUMNS表中常用字段

SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
column_name = 'hospital_id'

SELECT

*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
column_name = 'hosp_id'