但我们对一个项目不熟悉的时候
可能需要知道一个字段在哪些表中
只需要执行
```
SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'xxx' ;
```
xxx替换成需要查找的表名即可
information_schema 记录了数据库的各种信息,库的结构、表的结构、字段的结构
示例
```
mysql> SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'intro' ;
+--------------+------------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------------+
| laraveladmin | news |
| laraveladmin | news_20201011 |
| laraveladmin | news_bak |
| laraveladmin | news_dev |
+--------------+------------------+
4 rows in set (0.10 sec)
```