mysql简历项目分享_mysql 表分区简历（备忘）

练习且记录

1、准备表，创建一个测试表

create table tabletest(

uno int(5) primary key,

uname varchar(24)

);

2、插入数据

insert into tabletest(uno,uname) values(8003,'测试1');

insert into tabletest(uno,uname) values(8005,'测试2');

insert into tabletest(uno,uname) values(8006,'测试3');

insert into tabletest(uno,uname) values(8007,'测试4');

insert into tabletest(uno,uname) values(8000,'测试5');

insert into tabletest(uno,uname) values(8001,'测试6');

insert into tabletest(uno,uname) values(8002,'测试7');

insert into tabletest(uno,uname) values(8004,'测试8');

3、查询结果

select * from tabletest

4、建立分区，按照uno的值进行设定分区规则如下：

alter table tabletest partition by range(uno)

(

partition part0 values less than (8001),

partition part1 values le