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 ensure that people with status=notverified are deleted from the database after 30 seconds, how to do this I want to achieve this all by assigning a Sql query using, 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

P粉087951442 · Answer

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 )