Here’s a simple stored procedure I find myself using for MySQL over and over again. If you use a person’s email address as a database key, you may need to occasionally update their email address, and as such, you should update all references. Here’s a simple stored procedure to accomplish this:
DELIMITER $$
DROP PROCEDURE IF EXISTS [...]