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
Range Partition
How to Resolve ERROR 1481 (HY000): MAXVALUE can only be used in last partition definition
ERROR 1481 (HY000) In practice, we usually provide a default partition for settling remainders row of tables when we apply range partitions. mysql> alter table… Read More »How to Resolve ERROR 1481 (HY000): MAXVALUE can only be used in last partition definition
How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT
ERROR 1697 (HY000) Using a date or int column as a partition key is a lot easier than using a timestamp column in MySQL. Because… Read More »How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT