查询某数据库的某字段存在于哪些表 mysql

select column_name,column_comment,data_type ,table_name 

from information_schema.columns 

where table_schema='ld_express' and column_name = 'customer_id'
原文地址:https://www.cnblogs.com/xueblvip/p/15003528.html