MySQL Forums
Forum List  »  Triggers

Re: Issues with converting update command to trigger
Posted by: Peter Brawley
Date: July 15, 2020 10:33AM

> IF (NEW'.unit_of_measure'='%') THEN

1 Column does not exist in my version of this table

2 Backtick not quote: NEW.unit_of_measure or NEW.`unit_of_measure`

3 Period before the backtick

> ELSEIF (NEW.'unit_of_measure'='F')

Missing THEN

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.