Partition Key Makes Unique Index UselessNovember 25, 2015December 17, 2022Normally, 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
How to Resolve ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning functionJuly 28, 2013December 8, 2022ERROR 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