平成30/ 2018-10-20 06:04
mysql/ columns information_schema テーブル名 カラム名

# カラムを表示
show columns from sample;

# etc.
select column_name from information_schema.columns where table_name = 'req_doc';

select distinct TABLE_NAME from information_schema.columns;
select table_name, column_name from information_schema.columns;
select table_name, column_name from information_schema.columns where column_name like '%mail%';

(参考)
http://troubledteenservices.com/columns-table.html

SHOW COLUMNS 構文
http://dev.mysql.com/doc/refman/5.1/ja/show-columns.html