1.查找某个表属于哪个数据库
SELECT table_schema FROM information_schema.TABLES WHERE table_name = '表名字';
2.查找某个字段在哪个数据库和表中有使用到:
select table_schema,table_name from information_schema.columns where column_name = '字段名字'
1.查找某个表属于哪个数据库
SELECT table_schema FROM information_schema.TABLES WHERE table_name = '表名字';
2.查找某个字段在哪个数据库和表中有使用到:
select table_schema,table_name from information_schema.columns where column_name = '字段名字'