导出数据库表结构

IDEA不能导出表结构数据，我下载了插件又连不上数据库，只能曲线救国，反正只要能导出，自己再加工一下就好了。

SELECT
    t.table_name AS '表名',
    t.table_comment AS '说明',
    c.column_name AS '列名',
    c.column_comment AS '列说明',
    c.data_type AS '数据类型',
    CASE WHEN c.column_key = 'PRI' THEN '是' ELSE '否' END AS '是否为主键'
FROM
    information_schema.tables AS t
        INNER JOIN information_schema.columns AS c ON t.table_name = c.table_name
WHERE
        t.table_schema = 'your_database'
ORDER BY
    t.table_name, c.ordinal_position;

查出来后在把数据以csv或xlsx格式导出就好了，我用csv乱码，所以用了xlsx
呈现效果：