MySQL Forums
Forum List  »  Partitioning

Re: Question about adding partitions to a table?
Posted by: Erik Ljungstrom
Date: January 04, 2008 04:39AM


Yes, I believe you would end up getting the
ERROR 1481 (HY000): VALUES LESS THAN value must be strictly increasing for each partition
message if you attempted to add a partition if you've previously included a MAXVALUE partition. Should that be absolutely necessary, I suppose you could copy the contents of the maxvalue partition to a temporary table, drop it and then add another partition and copy the data back again.

Erik Ljungstrom

Options: ReplyQuote

Written By
Re: Question about adding partitions to a table?
January 04, 2008 04:39AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.