MySQL Forums
Forum List  »  Partitioning

Re: particular field type not allowed to this type of partitioning
Posted by: Mattias Jonsson
Date: August 24, 2012 04:15AM

In 5.5 you can also use RANGE COLUMNS partitioning without TO_DAYS():
PARTITION BY RANGE COLUMNS (fldassigndate)
(PARTITION p_Apr VALUES LESS THAN ('2012-05-01'),
PARTITION p_May VALUES LESS THAN ('2012-06-01'),
PARTITION p_Nov VALUES LESS THAN MAXVALUE );

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: particular field type not allowed to this type of partitioning
2073
August 24, 2012 04:15AM


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.