快速理清数据库中表之间的关系

得到指定的库对应的全部表名和列名以及他们的注释sql

SELECT b.table_name AS "表名称", b.Table_comment AS "表注释", a.column_name AS "字段名称",a.data_type AS '数据类型', a.column_comment AS "字段注释" 
FROM (
	SELECT column_name, Table_name, column_comment, table_schema,data_type
	FROM information_schema.columns
	WHERE table_schema = "这里输入要查询的库的名称"
) a
	LEFT JOIN (
		SELECT table_name, Table_comment, table_schema
		FROM information_schema.tables
	) b
	ON a.Table_name = b.table_name
		AND a.table_schema = b.table_schema