mysql 查询表注释

#查询数据库表内列名及列注释
select  column_name, column_comment from information_schema.columns where table_schema ='db name'  and table_name = 'table name' ;

 

End.