MySQL Forums
Forum List  »  Newbie

Re: How to delete millions of record in a loop
Posted by: pandu hondu
Date: November 17, 2016 05:51PM

No delete doesn't do the same thing like truncate. You are the ability to rollback in delete but not in truncate(if someone changes decision at last minute).
You say that you want to delete records selectively, but the end result of your procedure is to delete all of the rows in the table, i.e. it keeps deleting 'n' rows at a time until there are no rows left to delete.

No my wording might be wrong here. To delete all rows matching where clause.

Options: ReplyQuote




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.