Partition Key Makes Unique Index Useless
Normally, we build an unique index for protecting the table from inserting duplicate values of combined columns. If the constraint of the unique index is… Read More »Partition Key Makes Unique Index Useless
ERROR 1503 (HY000)
How to Resolve ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
ERROR 1503 (HY000) Tried to partition a table, but it failed with ERROR 1503 (HY000). Primary Key mysql> ALTER TABLE orders PARTITION BY RANGE(unix_timestamp(order_time)) (PARTITION… Read More »How to Resolve ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function