MySQL

Using MySQL TIMESTAMPDIFF to delete unverified user records

Posted on

Building a public website with user registration and email verification is typical. It will require users to validate their email by clicking a unique generated URL link. Sometimes, user registration with pending verification will grow exponentially and needs an automated cleanup of records. In this example I created a simple MySQL stored procedure to delete […]