Avatar of jnikodym

asked on 

SQL Trigger

I need to write a SQL trigger for a table.  I need the trigger to look at the value in FIELD A and copy that value and move that value to FIELD B.  I then need it to put a zero in FIELD A.  So, if FIELD A started with a value of 100 my end result would be a value of 0 in FIELD A and a value of 100 in FIELD B.  I need help with the correct syntax to make this happen.
MySQL Server

Avatar of undefined
Last Comment
Mark Wills

8/22/2022 - Mon