mysql 查询表注释

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

 

End.

posted @ 2014-02-26 11:13  lianche  阅读(273)  评论(0编辑  收藏  举报