MySQL生成数据库设计表格

写毕设论文要弄下面这种格式的数据库设计，嫌麻烦就写了一个SQL，结合navicat就可以导出Excel 再复制到 Word文档。

set @db_name='数据库名';
set @table_name='表名';
SELECT
	COLUMN_NAME 字段名,
	COLUMN_TYPE 数据类型,
IF
	(
		COLUMN_NAME IN ( SELECT COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE AS T WHERE T.table_schema = @db_name AND T.table_name = @table_name ),
		'PRIMARY KEY',
	IF
		( IS_NULLABLE = 'NO', 'NOT NULL', 'NULL' ) 
	) AS `主键/允许空`,
	COLUMN_COMMENT 字段含义 
FROM
	INFORMATION_SCHEMA.COLUMNS 
WHERE
	table_schema = @db_name 
	AND table_name = @table_name;

效果