创建一个测试表test.user,结构如下:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
1.Range分区 CREATE TABLE `abc` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `account` VARCHAR(255) NOT NULL COMMENT '账号', `passwd` VARCHAR(255) NOT NULL COMMENT '加密密码', `salt` VARCHAR(10) NOT NULL COMMENT 'salt', `state` ENUM('0','1','2') NOT NULL DEFAULT '0' COMMENT '状态,0正常', PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=5 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC PARTITION BY RANGE (id) (PARTITION p0 VALUES LESS THAN (5) ENGINE = INNODB, PARTITION p1 VALUES LESS THAN (10) ENGINE = INNODB, PARTITION p2 VALUES LESS THAN (15) ENGINE = INNODB, PARTITION p3 VALUES LESS THAN (20) ENGINE = INNODB) |
查看分区情况:
[crayon-5ae0a77f2db0766473559[……]