Changes between Version 8 and Version 9 of Partition

Timestamp:

06/16/22 01:04:50 (2 years ago)

Author:

krit

Comment:

--

Partition

@@ -6 +6 @@
 }}}
 
-2. create table payments2. primary key MUST include in PARTITION
+2. create table payments2. primary key MUST include in PARTITION. In this example, the primary key consists of two fields but the partition is defined on a single column. The partitioning rules require that the partition field should be part of the primary key, so whatever number of fields compose the primary key, a partition must employ at least one.
 {{{
 mysql> CREATE TABLE payments2 (