MYSQL: ROW_FORMAT；

前言

今天在导出表的时候，偶然发现每张表后面都跟了一个：ROW_FORMAT = Dynamic

CREATE TABLE `class`  (
  `class_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '班级id',
  `class_name` varchar(50) NOT NULL COMMENT '班级姓名',
  `class_no` varchar(20) NOT NULL COMMENT '班级编号',
  PRIMARY KEY (`class_id`) USING BTREE,
  UNIQUE INDEX `index_class_no`(`class_no`) USING BTREE COMMENT '班级编号唯一'
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

 

1. ROW_FORMAT-----数据库行格式：compact、compressed、default、dynamic、fixed、redundant

 

2. 修