全局搜索字段所在位置
SELECT COLUMN_NAME,TABLE_SCHEMA,TABLE_NAME
FROM information_schema.COLUMNS
WHERE COLUMN_NAME='字段名字'
+---------------+--------------+---------------+
| COLUMN_NAME | TABLE_SCHEMA | TABLE_NAME |
+---------------+--------------+---------------+
| contacts_name | dxxxf_v3 | fledts |
| contacts_name | dxxxf_v3 | losdftions |
| contacts_name | dxxxf_v3 | orgafsizatsdons |
| contacts_name | pxxnf | afdts |
| contacts_name | sxxmens | lafions |
| contacts_name | pxxmedfs | sgdszations |
+---------------+--------------+---------------+
————————————————
本文由 小马哥 创作,采用 知识共享署名4.0 国际许可协议进行许可
本站文章除注明转载/出处外,均为本站原创或翻译,转载前请务必署名
最后编辑时间为:
2020/03/01 14:00