mysql 通过=或是like字段ATTACH_ID,查询属于哪个表。
SELECT TABLE_NAME FROM information_schema.COLUMNS WHERE COLUMN_NAME like ‘%ATTACH_ID%‘;
结果:
dc_license_recognition
rpt_asset_report
d_acc_bank_bind
通过某个表查询该表属于哪个数据库。
SELECT table_schema FROM information_schema.TABLES WHERE table_name = ‘dc_license_recognition‘;
结果:
ner_datacenter