Mysql导出数据库设计
查询SQLSELECTTABLE_NAME 表名,COLUMN_NAME 列名,COLUMN_COMMENT 释义,DATA_TYPE as 类型,CHARACTER_MAXIMUM_LENGTH as 长度,COLUMN_TYPE as 类型和长度,IS_NULLABLE as 'NULL'FROM INFORMATION_SCHEMA.COLUMNSwhere-- test 为数据库名称,到时候只需要修改成你要导出表结构的数据库即可table_schema ='test'ord