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

Written By
December 07, 2010 08:35AM
December 08, 2010 10:01PM
Re: Partition by year and month
December 13, 2010 03:07AM
December 13, 2010 08:22AM
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.