mysql表结构输出文档sql

SELECT
    Column_Name AS '字段名称',
    data_type AS '数据类型',
    (
    CASE
            
            WHEN data_type = 'float' 
            OR data_type = 'double' 
            OR data_type = 'TINYINT' 
            OR data_type = 'SMALLINT' 
            OR data_type = 'MEDIUMINT' 
            OR data_type = 'INT' 
            OR data_type = 'INTEGER' 
            OR data_type = 'decimal' 
            OR data_type = 'bigint' THEN
                NUMERIC_PRECISION ELSE CHARACTER_MAXIMUM_LENGTH 
            END 
            ) AS '长度(整数)',
            NUMERIC_SCALE AS '长度(小数)',
            ( CASE WHEN EXTRA = 'auto_increment' THEN '是' ELSE '否' END ) AS '是否自增',
            ( CASE WHEN IS_NULLABLE = 'NO' THEN '否' ELSE '是' END ) AS '能否为空',
            ( CASE WHEN COLUMN_KEY = 'PRI' THEN '是' ELSE '否' END ) AS '是否是主键',# extra,
            COLUMN_DEFAULT AS '默认值',
            COLUMN_COMMENT AS '约束条件与说明' 
        FROM
            information_schema.COLUMNS 
        WHERE
        TABLE_SCHEMA = '数据库名称' 
    AND TABLE_NAME = '表名称'