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
呈现效果: