MySQL Forums
Forum List  »  Triggers

Re: Issues with converting update command to trigger
Posted by: Shawn Logan
Date: July 03, 2020 02:53AM

Error
SQL query: Documentation


CREATE TRIGGER add_desc BEFORE insert on telemetry_log FOR EACH ROW
set new.device_desc = ( select device_desc from id_name_device where device_id=new.device_id );
end;
MySQL said: Documentation

#1064 - 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 'end' at line 3

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.