msyql全局搜索字段所在位置

/ 数据库 / 2 条评论 / 1419浏览

全局搜索字段所在位置


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 |
+---------------+--------------+---------------+
————————————————