mysql导出表结构到一张excel表

SELECT
t.table_name AS ‘表名’,
t.table_comment AS ‘中文名’,
sc.column_name AS ‘字段’,
sc.column_type AS ‘类型’,
sc.is_nullable AS ‘是否为空’,
sc.column_default AS ‘默认值’,
sc.column_comment AS ‘备注’
FROM
information_schema.COLUMNS sc JOIN information_schema.TABLES t ON sc.table_name = t.TABLE_NAME JOIN information_schema.KEY_COLUMN_USAGE c ON t.TABLE_NAME = c.table_name
WHERE
sc.table_schema = ‘uat_credit_upright’;
在可视化工具navicat中执行sql，然后点击导出查询结果就可以导出来所有的表结构。