One of the easiest way to upgrade MySQL installation is by first backing up the existing database and removing all traces of MySQL from the system. sudo apt remove –purge mysql* sudo apt autoremove sudo apt autoclean sudo apt remove dbconfig-mysql
In MySQL, If you have an existing table and you want to have unique index across multiple columns. You can use the snippet below. ALTER TABLE `prefix_counter` ADD UNIQUE `unique_prefix_counter`(`prefix`, `year`);
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 […]