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