select column_name, column_comment from information_schema.columns where table_schema =‘db name‘ and table_name = ‘table name‘ ;
查询数据库表内列名及列注释
mysql 查询表注释,布布扣,bubuko.com
mysql 查询表注释
原文:http://www.cnblogs.com/lianche/p/3568665.html