MySQL Forums
Forum List  »  Data Recovery

Re: Cleanup data from huge table
Posted by: Peter Brawley
Date: February 22, 2018 09:06AM

delete ... where timestampdiff( month, datecol, curdate() ) > 6

Options: ReplyQuote


Subject
Views
Written By
Posted
864
February 21, 2018 04:30AM
586
February 21, 2018 12:24PM
547
February 22, 2018 12:42AM
Re: Cleanup data from huge table
526
February 22, 2018 09:06AM
502
February 23, 2018 12:40AM


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.