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

select column_name,column_comment,data_type ,table_name 

from information_schema.columns 

where table_schema='ld_express' and column_name = 'customer_id'

 

posted @ 2021-07-12 19:30  薛柏梁  阅读(122)  评论(0编辑  收藏  举报