一个SQL快速导出MySQL数据库表结构

一个SQL快速搞定MySQL数据库表结构

SELECT
	t.TABLE_NAME AS 表名,
	t.TABLE_COMMENT AS 表注释,
	c.COLUMN_NAME AS 字段名,
	c.COLUMN_COMMENT AS 字段注释
FROM
	INFORMATION_SCHEMA.TABLES AS t,
	INFORMATION_SCHEMA.COLUMNS AS c 
WHERE
	c.TABLE_NAME = t.TABLE_NAME 
	AND t.TABLE_SCHEMA = 'root';