复制CREATE TABLE employees ( emp_no int(11) NOT NULL,分分区 birth_date date NOT NULL, first_name varchar(14) NOT NULL, last_name varchar(16) NOT NULL, gender char(1) DEFAULT NULL, hire_date date NOT NULL ) ENGINE=MyISAM PARTITION BY RANGE COLUMNS(gender,hire_date) (PARTITION p01 VALUES LESS THAN (F,1990-01-01) , PARTITION p02 VALUES LESS THAN (F,2000-01-01) , PARTITION p03 VALUES LESS THAN (F,MAXVALUE) , PARTITION p04 VALUES LESS THAN (M,1990-01-01) , PARTITION p05 VALUES LESS THAN (M,2000-01-01) , PARTITION p06 VALUES LESS THAN (M,MAXVALUE) , PARTITION p07 VALUES LESS THAN (MAXVALUE,MAXVALUE) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16. |
喜欢
讨厌