HMShingala

To delete data of some fix date and time use below mention query in your code.

DELETE FROM tbl_user WHERE date < DATE_SUB(NOW(), INTERVAL 7 DAY)

In above query “INTERVAL 7 DAY” here you can set any number of days like 1, 2, 5 etc…

Leave a Reply

Your email address will not be published. Required fields are marked *