查看mysql数据库表结构注释信息

SELECT table_name 表名, table_comment 表说明
  FROM information_schema.TABLES 
  WHERE table_name in ( 
          select  table_name  
         from information_schema.columns  
       where table_schema='shanwei'  )    
  ORDER BY table_name
 ;
 
  
 
 select COLUMN_NAME 字段名,column_type 字段类型,is_nullable `是否为空`,
  column_key 约束 ,column_comment 注释 ,table_name 表名  
    from information_schema.columns  a
  where table_schema='shanwei'  
    order by  table_name 
    ;