MySQL Forums
Forum List  »  Newbie

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

Sincerely appreciate both of your help, Let me try your code and get back to you.

Truncate is fast but data is lost, I want to delete records selectively with 'where' clause.

I hope that clarifies why I use delete and not truncate.

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.