平成30/ 2018-12-16 11:35
MYSQL/テーブルのカラム名、コメントとか取得

select column_comment from  information_schema.columns where table_schema='dbname' and table_name = 'tablename';
select column_name from  information_schema.columns where table_schema='dbname' and table_name = 'tablename';
select data_type from  information_schema.columns where table_schema='dbname' and table_name = 'tablename';


___ Thanks.
[MySQL-開発で使いそうなSQL] カラム名の一覧を取得する
http://momoya.me.land.to/?pid=146