You could provide a trigger, and execute a stored procedure to do this:
MySql Trigger[
^] But You will have to be careful when you write the SP: make sure you are only doing this for the one record. You had also better document this pretty damn well because it is going to confuse some poor sod one day!
Instead, I would do it in code: easier to see, easier to understand - particularly if it is a one-off operation.
Submit an article or tip