MySQL Forums
Forum List  »  Partitioning

Week Partitioning
Posted by: Frank Schuster
Date: July 17, 2009 03:25AM


I have a table with a column date and I want to store all datas about the year in the table and will it partioning by 52 weeks.
The question is, what Type of Partitioning is recommended?

The problem is and I don't know how I can solve it is: When the 52 weeks are over, I want that the entries of the oldest week are deleted and a new partition will be add - so I get a constant number of partition.

I hope you can understand the problem or you can ask me.


Options: ReplyQuote

Written By
Week Partitioning
July 17, 2009 03:25AM
July 18, 2009 12:07PM
July 20, 2009 03:29AM
August 06, 2009 04:02PM

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.