2024年1月6日发(作者：)
mysql分区表建表语句
1、按照日期范围分区
```sql CREATE TABLE student ( id INT,
name VARCHAR(255), birthday DATE ) PARTITION
BY RANGE (birthday) ( PARTITION p0 VALUES LESS
THAN ('2017-01-01'), PARTITION p1 VALUES LESS
THAN ('2017-02-01'), PARTITION p2 VALUES LESS
THAN ('2017-03-01'), PARTITION p3 VALUES LESS
THAN (MAXVALUE) ); ```
2、按照数值范围分区
```sql CREATE TABLE student ( id INT,
name VARCHAR(255), score INT ) PARTITION BY
RANGE (score) ( PARTITION p0 VALUES LESS THAN
(60), PARTITION p1 VALUES LESS THAN (70),
PARTITION p2 VALUES LESS THAN (80), PARTITION
p3 VALUES LESS THAN (MAXVALUE) ); ```
3、按照列表分区
```sql CREATE TABLE student ( id INT,
name VARCHAR(255), city VARCHAR(255) )
PARTITION BY LIST (city) ( PARTITION p0 VALUES
IN ('Beijing', 'Shanghai'), PARTITION p1
VALUES IN ('Guangzhou', 'Shenzhen'),
PARTITION p2 VALUES IN ('Hangzhou', 'Nanjing'),
PARTITION p3 VALUES IN (MAXVALUE) ); ```
发布者：admin，转转请注明出处：http://www.yc00.com/news/1704481556a1353939.html
评论列表（0条）