快速生成mysql表的描述

SELECT 
    column_name AS `列名`,    
    CONCAT_WS(' (', data_type, character_maximum_length) AS `数据类型`,
    is_nullable AS `非空`,
    CASE
        WHEN extra = 'auto_increment'
        THEN 'Yes'
        ELSE '' 
    END AS `主键`,
    column_default  AS  `默认值`,
    column_comment AS `备注` 
FROM
    Information_schema.columns 
WHERE table_Name = 'table_name' ;

  我们只要把 table_name 换成自己的表面就行了。很方便的呢。所以我推荐给大家.