mysql数据字典导出word

SELECT 
    TABLE_NAME AS '表名',
    COLUMN_NAME AS '列名',
    DATA_TYPE AS '数据类型',
    CHARACTER_MAXIMUM_LENGTH AS '最大长度',
    IS_NULLABLE AS '是否允许为空',
    COLUMN_DEFAULT AS '默认值',
    COLUMN_COMMENT AS '注释'
FROM 
    INFORMATION_SCHEMA.COLUMNS
WHERE 
    TABLE_SCHEMA = 'your_database_name'
ORDER BY 
    TABLE_NAME, ORDINAL_POSITION;

SELECT 
    TABLE_NAME AS '表名',
    COLUMN_NAME AS '列名',
    DATA_TYPE AS '数据类型',
    CHARACTER_MAXIMUM_LENGTH AS '最大长度',
    IS_NULLABLE AS '是否允许为空',
    COLUMN_DEFAULT AS '默认值',
    COLUMN_COMMENT AS '注释'
INTO OUTFILE '/path/to/your/output.csv'
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
'
FROM 
    INFORMATION_SCHEMA.COLUMNS
WHERE 
    TABLE_SCHEMA = 'your_database_name'
ORDER BY 
    TABLE_NAME, ORDINAL_POSITION;

SET NAMES utf8mb4;
SELECT 
    ...
INTO OUTFILE ...
FROM 
    ...
WHERE 
    ...
ORDER BY 
    ...;