MySQL分区琐碎
来源:互联网 发布:淘宝二手自行车怎么样 编辑:程序博客网 时间:2024/05/21 18:39
新创建表设置分区:
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 report_slotinfo partition by RANGE(id)
(
PARTITION p1 VALUES less than (1000000),
PARTITION p2 VALUES less than (2000000),
PARTITION p3 VALUES less than (3000000),
PARTITION p4 VALUES less than (4000000),
PARTITION p5 VALUES less than (5000000),
PARTITION p6 VALUES less than (6000000),
PARTITION p7 VALUES less than (7000000),
PARTITION p8 VALUES less than (8000000),
PARTITION p9 VALUES less than (9000000),
PARTITION p10 VALUES less than (10000000),
PARTITION p11 VALUES less than MAXVALUE
);
删除分区:
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 report_slotinfo partition by RANGE(id)
(
PARTITION p1 VALUES less than (1000000),
PARTITION p2 VALUES less than (2000000),
PARTITION p3 VALUES less than (3000000),
PARTITION p4 VALUES less than (4000000),
PARTITION p5 VALUES less than (5000000),
PARTITION p6 VALUES less than (6000000),
PARTITION p7 VALUES less than (7000000),
PARTITION p8 VALUES less than (8000000),
PARTITION p9 VALUES less than (9000000),
PARTITION p10 VALUES less than (10000000),
PARTITION p11 VALUES less than MAXVALUE
);
查看某表的分区情况:
select * from INFORMATION_SCHEMA.PARTITIONS where table_name='report_slotinfo';
删除分区:
ALTER TABLE 表名 DROP PARTITION 分区名;
牛人博客:
http://blog.51yip.com/mysql/1013.html
- MySQL分区琐碎
- Mysql那些琐碎
- mysql琐碎知识点
- mysql一些琐碎知识点
- 琐碎
- 琐碎
- 琐碎
- 琐碎
- 琐碎
- 琐碎
- 琐碎
- MySQL分区--列表分区
- MySQL分区--列分区
- Mysql分区?
- mysql分区
- mysql分区
- MySQL分区
- mysql分区
- C#打开文件夹
- 图像编辑之对比度调整(亮度对比度的算法公式)
- uboot 学习
- 尼姆博弈————(杭电2176题)可以做!
- 高新技术知识点总结01
- MySQL分区琐碎
- Ext.net 往后台传递参数
- Raspberry Pi(树莓派)试用小记
- 如何用SQLPLUS远程登服务器?
- 高新技术知识点总结02
- Linux makefile详解
- 批处理命令FOR循环命令详解!
- 新加源码包在源码下编译步骤
- 高新技术知识点总结03