This question already has an answer here:
I would like to know how auto delete row from MySQL database. I have seen examples of people using MySQL event but I'm not sure how to use it.
In the database, is there a way for me to use timestamp and use interval 24 hours to delete a row?
For example, if a user doesn't activate their account in 24 hours, it should auto-delete from the database.
</div>