MySQLで特定のカラムが存在するか確認する

MySQL

SQL文†

select table_name from information_schema.columns where column_name = '確認したいカラム' and table_schema = '対象データベース';

実行例†

mysql> select table_name from information_schema.columns where column_name = 'user' and table_schema = 'mysql';
+--------------+
| table_name   |
+--------------+
| columns_priv |
| db           |
| procs_priv   |
| proxies_priv |
| tables_priv  |
| user         |
+--------------+
6 rows in set (0.00 sec)