如何根据特定列名检查数据库中的 MySQL 表?
mysqlmysqli database
以下语句显示了示例数据库中包含"email"列的两个表的列表 −
mysql> SELECT DISTINCT TABLE_NAME -> FROM INFORMATION_SCHEMA.COLUMNS -> WHERE COLUMN_NAME IN('EMAIL') -> AND TABLE_SCHEMA = 'SAMPLE'; +---------------+ | TABLE_NAME | +---------------+ | employee | | new_student | +---------------+ 2 rows in set (0.04 sec)