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
919
February 21, 2018 04:30AM
626
February 21, 2018 12:24PM
577
February 22, 2018 12:42AM
Re: Cleanup data from huge table
557
February 22, 2018 09:06AM
540
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.