mysql 查询字段在哪个表

2017-06-13 本文已影响0人 jasonlu1208

SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'col1'