MySQL Forums
Forum List  »  Partitioning

Re: Partition by year and month
Posted by: IGGt .
Date: December 13, 2010 03:07AM

cheers, that is unfortuante.

Looking at the documentation it suggests that you can't use a datetime value for partitioning, without converting it first e.g "PARTITION BY RANGE( TO_DAYS(RecTime) )"

Is this still the case, as one of my colleagues thinks he read that this has now changed, and we can partition by datetime (something like "PARTITION BY RANGE( (RecTime) )", but I can't find any mention of it.

This could be in either MySQL 5.1x or 5.5x.

Options: ReplyQuote


Subject
Views
Written By
Posted
23418
December 07, 2010 08:35AM
8514
December 08, 2010 10:01PM
Re: Partition by year and month
7506
December 13, 2010 03:07AM
6884
December 13, 2010 08:22AM
7152
December 13, 2010 08:25AM


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.