如何在Mysql数据库中设置时间间隔[重复]

Question

This question already has an answer here:

• How to delete a MySQL record after a certain time 3 answers
• delete whole row after x mins in mysql db and PHP 5 answers

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>