Delete record auto after certain time
i have a table where normal records are added.
Ie: PhoneNumber, OTP (6 digit numbers), TimeAdded (format : 2016-10-03 16:44:48)
This generally works as OTP which is sent to users mobile.
When records are entered i want these records (row) to delete automatically after 1 hour using 'TimeAdded'.
How can this be achieved ?