获取表comment 注释信息

        use information_schema; 
            select 'alter table ' || TABLE_SCHEMA ||'.' || table_name || ' comment ''' || table_comment ||''';'  sqlstr
              from TABLES 
             where TABLE_SCHEMA='bjnxy' 
               and TABLE_NAME='whj_01';