How can I execute a script in mysql?

Question

Database entry image I have a database (example of records in the database are below) and I need to make sure that people with status = notverified are deleted from the database after 30 seconds, how to do this

I want to achieve all this by assigning the Sql query used, but I don't like this idea because there is no such button on the website and it needs to be pressed frequently to work properly

Answer 1

You can use chronjob in mysql to do this. (If it's mysql, here's a link: https://dev.mysql.com/doc/refman/ 5.7/en/create-event.html )