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…
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…