How to delete data from the database after a certain time?

Question

PHP

The data is written to the database. It is necessary after a certain time to delete this entry if certain data (request) has not been received. How can this be implemented?

Answer 1

Put a timestamp on records and delete old data when starting the script that uses them (that is, first DELETE ... WHERE timestamp < DATE_SUB(NOW(), INTERVAL 15 MINUTE), and then SELECT).

Answer 2

If MySQL is rooted, then CREATE EVENT