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 1481 (HY000): MAXVALUE can only be used in last partition definitionSeptember 29, 2014December 9, 20221 CommentERROR 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 INTSeptember 3, 2013December 8, 20222 CommentsERROR 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