MySQL快速生产表的描述

# 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' ;