SELECT * from (select column_name,TABLE_NAME from information_schema.columns
where table_schema ='数据库名') a
where a.column_name = '字段名'
SELECT * from (select column_name,TABLE_NAME from information_schema.columns
where table_schema ='数据库名') a
where a.column_name = '字段名'