MySQL Forums
Forum List  »  Archive Storage Engine

Re: Enable deletion for archive engine.
Posted by: Tor-Ivar Valåmo
Date: November 06, 2009 08:52AM

What you would do in this instance is create one table per period of time. So if you'd want to delete the archive for one particular year (or month), you delete that one table for that year. This is easily done, as an archive table supports renaming. So you can replace your "production" table with an empty one, while renaming the current one to, say, myarchive_2009_10.

Options: ReplyQuote


Subject
Views
Written By
Posted
9017
November 02, 2009 01:31PM
4987
November 03, 2009 02:05PM
Re: Enable deletion for archive engine.
4749
November 06, 2009 08:52AM


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.