MySQL Forums
Forum List  »  Triggers

Re: Issues with converting update command to trigger
Posted by: Shawn Logan
Date: July 15, 2020 05:33AM

Would you please take a look at this syntax and tell me where i went wrong?

What i have so far throws a ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''unit_of_measure'='%') or

Here's what i have:

delimiter $$

CREATE TRIGGER `do_all` BEFORE INSERT ON `telemetry_log`

FOR EACH ROW

Begin

SET new.device_desc = ( select device_desc from id_name_update where device_id=new.device_id );

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

SET new.val_cal = ( select hum_cal from id_name_update where device_id=new.device_id);

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


SET new.val_cal = ( select temp_cal from id_name_update where device_id=new.device_id);

END IF;

SET new.value = new.value + new.val_cal;

END$$
DELIMITER ;

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.