I ask for your cooperation with the following MySql trigger.
UPDATE sales SET date = now () WHERE status = & # 39; Current & # 39 ;; UPDATE sales SET update = "system" WHERE status = & # 39; Canceled & # 39 ;;
The trigger works,
but I would like to know how to do something like this:
UPDATE sales SET date = now () WHERE status = & # 39; valid & # 39 ;, SET Update = "System" WHERE Status = & # 39; Canceled & # 39 ;;
The previous thing is that I have a Tigger in the sales table before the update and I want to do a single update for the line, not two, as this happens.