More than 5 years have passed since last update.

特定のカラム名を持つテーブルを洗い出す。

MySQL

Posted at 2016-01-28

複数のデータベースに対して
特定のカラム名を持つテーブルを洗い出す場合のSQL実行分

SELECT table_schema,table_name, column_name FROM information_schema.columns 
WHERE 
column_name = 'カラム名'

 AND (table_schema = 'データベース名' OR table_schema = 'データベース名' OR....
);

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up