MySQL分区表(转)

1. alter table w drop partition p2010;

1. CREATE TABLE m (
   
2. a INT,
   
3. b INT)ENGINE=innnodb
   
4. PARTITION BY LIST (b)(
   
5. PARTITION p0 VALUES IN (1,2,3,4,5),
   
6. PARTITION p1 VALUES IN (6,7,8,9,10));
   
8. insert into m values (1,6),(2,7),(3,11),(4,9)

1. CREATE TABLE m_hash (
   
2. a INT,
   
3. b DATETIME)ENGINE=innnodb
   
4. PARTITION BY HASH (YEAR(b)) --"partition by hash (expr)" expr是一个返回整数的表达式
   
5. PARTITIONS 4; --表示要被分割成分区的数量，没有则默认是1

1. PARTITION BY LINEAR HASH (YEAR(b))

1. CREATE TABLE t_columns_range(
   
2. a INT,
   
3. b DATETIME) ENGINE=INNODB
   
4. PARTITION BY RANGE COLUMNS (b) --也可以PARTITION BY LESS COLUMNS (b)
   
5. (PARTITION p0 VALUES LESS THAN(‘2009-01-01‘),
   
6. PARTITION p1 VALUES LESS THAN(‘2010-01-01‘));

MySQL分区表(转),布布扣,bubuko.com