mysql通过表明查询在那个数据库下(注:只查询当前ip下的)
SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
FROM information_schema.COLUMNS
WHERE COLUMN_NAME = '表名'
mysql通过表明查询在那个数据库下(注:只查询当前ip下的)
SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME
FROM information_schema.COLUMNS
WHERE COLUMN_NAME = '表名'