Mysql 分区介绍(五) —— LIST COLUMNS分区

yiwai

CREATE TABLE customers_2 (　　first_name VARCHAR(25),
　　last_name VARCHAR(25),
　　street_1 VARCHAR(30),
　　street_2 VARCHAR(30),
　　city VARCHAR(15),
　　renewal DATE
　　)
　　PARTITION BY LIST COLUMNS(renewal) (
　　PARTITION pWeek_1 VALUES IN('2010-02-01', '2010-02-02', '2010-02-03',
　　'2010-02-04', '2010-02-05', '2010-02-06', '2010-02-07'),
　　PARTITION pWeek_2 VALUES IN('2010-02-08', '2010-02-09', '2010-02-10',
　　'2010-02-11', '2010-02-12', '2010-02-13', '2010-02-14'),
　　PARTITION pWeek_3 VALUES IN('2010-02-15', '2010-02-16', '2010-02-17',
　　'2010-02-18', '2010-02-19', '2010-02-20', '2010-02-21'),
　　PARTITION pWeek_4 VALUES IN('2010-02-22', '2010-02-23', '2010-02-24',
　　'2010-02-25', '2010-02-26', '2010-02-27', '2010-02-28')
　　);