目的：
创建分区表并插入数据，验证数据存放效果。
思路：
创建分区表Music，共创建4个分区，分别为rock、pop、jazz和classic分区，往里面插入歌曲信息，并验证是否自动存放到响应的分区内。
创建分区表：
MariaDB [music]> CREATE TABLE music (
-> id INT NOT NULL,
-> name VARCHAR(30),
-> style VARCHAR(30),
-> style_code int NOT NULL
-> )
-> PARTITION BY LIST(style_code)
-> (PARTITION rock VALUES IN (1),
-> PARTITION pop VALUES IN (2),
-> PARTITION jazz VALUES IN (3),
-> PARTITION classic VALUES IN (4)
-> );
Query OK, 0 rows affected (0.04 sec)
插入数据：
MariaDB [music]> insert into music values(1,'Have a Nice Day','pop',2);
Query OK, 1 row affected (0.01 sec)
MariaDB [music]> insert into music values(2,'We will rock you','rock',1);
Query OK, 1 row affected (0.02 sec)
验证数据：
MariaDB [music]> select * from music;
+----+--------------------+---------+------------+
| id | name | style | style_code |
+----+--------------------+--------+------------+
| 2 | We will rock you | rock | 1 |
| 1 | Have a Nice Day | pop | 2 |
+----+--------------------+--------+------------+
2 rows in set (0.00 sec)
查看某个分区的数据：
MariaDB [music]> select * from music partition (pop);
+----+-----------------+-------+------------+
| id | name | style | style_code |
+----+-----------------+-------+------------+
| 1 | Have a Nice Day | pop | 2 |
+----+-----------------+-------+------------+
1 row in set (0.00 sec)
MariaDB [music]> select * from music partition (rock);
+----+------------------+-------+------------+
| id | name | style | style_code |
+----+------------------+-------+------------+
| 2 | We will rock you | rock | 1 |
+----+------------------+-------+------------+
1 row in set (0.00 sec)
OK~