MySQL分区表示例：创建range分区表

create table emp
(
	empno varchar(20) not null ,
	empname varchar(20),
	deptno int,
	birthdate date,
	salary int
)
partition by range(salary)
(
	partition p1 values less than (1000),
	partition p2 values less than (2000),
	partition p3 values less than maxvalue
);

--以员工工资为依据做范围分区。

create table emp
(
	empno varchar(20) not null ,
	empname varchar(20),
	deptno int,
	birthdate date not null,
	salary int
)
partition by range(year(birthdate))
(
	partition p1 values less than (1980),
	partition p2 values less than (1990),
	partition p3 values less than maxvalue
);

--以year(birthdate)表达式（计算员工的出生日期）作为范围分区依据。这里最值得注意的是表达式必须有返回值。