CREATE TABLE jiang (id int(11), content VARCHAR(20)) PARTITION by RANGE(id)( PARTITION id1 VALUES less than (5), PARTITION id2 VALUES less than (10), PARTITION id3 VALUES less than (15), PARTITION id4 VALUES less than MAXVALUE ) CREATE TABLE jiang1 (id INT(11), content VARCHAR(66)) PARTITION by HASH (id) PARTITIONS 4; CREATE TABLE jiang2 (id INT(11), content VARCHAR(77)) PARTITION by KEY (id) PARTITIONS 4; CREATE TABLE jiang4 ( id INT NOT NULL, store_id INT ) PARTITION BY LIST(store_id) ( PARTITION a VALUES IN (1,5,6), PARTITION b VALUES IN (2,7,8), PARTITION c VALUES IN (3,9,10), PARTITION d VALUES IN (4,11,12) );
四种 mysql 分区
最新推荐文章于 2023-08-20 17:17:10 发布