Creating a trigger for the mysql server to change the value from one part of the database and update it to another.