mysql导出数据库设计说明书

– 导出某一确定数据库的确定表的相关信息

set @rownum=0;

SELECT

@rownum:=@rownum+1 AS 序号,

COLUMN_COMMENT AS 列的描述,

COLUMN_NAME AS 列名,

COLUMN_TYPE AS 类型 ,

CHARACTER_MAXIMUM_LENGTH as 长度,

(CASE WHEN  IS_NULLABLE = ‘YES’ THEN ‘是’ ELSE ‘否’ END) AS 是否为空

FROM

information_schema.COLUMNS

WHERE

TABLE_SCHEMA = (select database()) AND

TABLE_NAME = (’t_draft_info’) ORDER BY  ORDINAL_POSITION ;

–导出确定数据库内的所有表的相关信息

set @rownum=0;

SELECT

@rownum:=@rownum+1 AS 序号 ,

t.TABLE_COMMENT AS 描述 ,

t.table_name AS 表名

FROM

information_schema.TABLES t

WHERE

t.TABLE_SCHEMA = (select database()) ORDER BY t.TABLE_NAME;

(windows同时安装多个mysql8.0服务)