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.
Subject
Views
Written By
Posted
30356
December 07, 2010 08:35AM
10203
December 08, 2010 10:01PM
Re: Partition by year and month
9134
December 13, 2010 03:07AM
8137
December 13, 2010 08:22AM
8731
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.