MySQL Forums
Forum List  »  Partitioning

Re: Partitioning by hour
Posted by: Rick James
Date: September 12, 2009 03:12PM

As I understand it, YEAR() and TO_DAYS() are the only functions that are really useful in this context.

A workaround might be to add a column, say loghour, and populate it accordingly. Then, instead of
logtime between "12:00:00" and "12:59:59"
use
loghour = 12.

BTW, what benefit did you hope to get out of PARTITIONing by hour? (I can't think of any.)

Options: ReplyQuote


Subject
Views
Written By
Posted
3689
September 11, 2009 01:32PM
Re: Partitioning by hour
2612
September 12, 2009 03:12PM
2415
September 12, 2009 09:31PM
3182
September 17, 2009 06:31AM
2527
September 17, 2009 08:45AM
2694
September 17, 2009 09:50AM
2499
September 21, 2009 03:55AM


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.