-- 全テーブルの全カラムコメント取得 SELECT TABLE_NAME AS `Table`, COLUMN_NAME AS `Column`, COLUMN_COMMENT AS Comment FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '検索したいDB名' -- AND COLUMN_COMMENT LIKE '%検索ワード%' ORDER BY TABLE_NAME, ORDINAL_POSITION; --- 特定カラムのNULLでない値を取得 SELECT id, column_name FROM table_nam…