mysql 分区学习

最新推荐文章于 2024-07-20 20:04:43 发布

weixin_34008784

最新推荐文章于 2024-07-20 20:04:43 发布

阅读量67

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/1388024/blog/3027970

版权

2019独角兽企业重金招聘Python工程师标准>>>

分区字段必须在主键内

CREATE TABLE employees (
    id INT NOT NULL,
    fname VARCHAR(30),
    lname VARCHAR(30),
    hired DATE NOT NULL DEFAULT '1970-01-01',
    separated DATE NOT NULL DEFAULT '9999-12-31',
    job_code INT NOT NULL,
    store_id INT NOT NULL
)
// 新建范围分区
PARTITION BY RANGE (store_id) (
    PARTITION p0 VALUES LESS THAN (6),
    PARTITION p1 VALUES LESS THAN (11),
    PARTITION p2 VALUES LESS THAN (16),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);

//删除分区
alter table employees drop partition p0;


//查看分区
SELECT PARTITION_NAME
FROM INFORMATION_SCHEMA.PARTITIONS
WHERE TABLE_NAME = 'employees';

select *  from employees

转载于:https://my.oschina.net/u/1388024/blog/3027970