Mysql：查表注释和列注释等

SELECT
	a.table_name 表名,
	a.table_comment 表说明,
	b.COLUMN_NAME 字段名,
	b.column_comment 字段说明,
	b.column_type 字段类型,
	b.column_key 约束 
FROM
	information_schema.TABLES a
	LEFT JOIN information_schema.COLUMNS b ON a.table_name = b.TABLE_NAME 
WHERE
	a.table_schema = 'park'   //数据库库名字
ORDER BY
	a.table_name

结果：

ranks	表注释	finish_date		datetime(6)	
ranks	表注释	id	注释	int(11)	PRI
ranks	表注释	mobile	注释22	varchar(255)	
ranks	表注释	score		int(255)	MUL
riddle		question		varchar(255)	
riddle		id		int(11)	PRI
riddle		requirement		varchar(255)	
riddle		answera		varchar(50)	
riddle		answerb		varchar(50)	
riddle		answerc		varchar(50)