SQL生成数据库设计文档

SELECT
	@Rownum := @Rownum + 1 序号,
	COLUMN_NAME 列名,
	COLUMN_TYPE 数据类型,
	CHARACTER_MAXIMUM_LENGTH 长度,
	NUMERIC_PRECISION 小数位,
CASE
		WHEN COLUMN_KEY = 'PRI' THEN
		'是' ELSE '' 
	END AS 主键,
CASE
		
		WHEN IS_NULLABLE = 'NO' THEN
		'是' ELSE '' 
	END AS "非空",
	COLUMN_DEFAULT 默认值,
	COLUMN_COMMENT 说明 
FROM
	( SELECT @rownum := 0 ) r,
	INFORMATION_SCHEMA.COLUMNS 
WHERE
	table_schema = '库名' 
	AND table_name = '表名' 
ORDER BY
	COLUMN_KEY DESC;