mysql创建分区表

最新推荐文章于 2024-09-13 10:17:01 发布

Snowballl

最新推荐文章于 2024-09-13 10:17:01 发布

阅读量723

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/minwang593/article/details/16943301

版权

mysql 专栏收录该内容

81 篇文章 0 订阅

订阅专栏

[root@datareport-backend ~]# mysql -h 10.2.254.237 -uroot -pmdvnUrteTIV46GOH
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 33
Server version: 5.5.28 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use test;
Database changed
mysql> CREATE TABLE p1
    -> (    a INT,
    -> b INT,
    -> c INT )
    -> PARTITION BY RANGE COLUMNS (a)
    ->   (    PARTITION p01 VALUES LESS THAN (10),
    ->     PARTITION p02 VALUES LESS THAN (20),
    ->      PARTITION p03 VALUES LESS THAN (30),
    ->    PARTITION p04 VALUES LESS THAN (MAXVALUE) );
Query OK, 0 rows affected (0.06 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.28 |
+-----------+
1 row in set (0.00 sec)