Re: Issues with converting update command to trigger
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
Subject
Views
Written By
Posted
2273
July 01, 2020 09:29AM
1091
July 01, 2020 09:33AM
984
July 01, 2020 02:07PM
1053
July 02, 2020 05:55AM
987
July 02, 2020 11:59AM
1425
July 02, 2020 07:10PM
1082
July 02, 2020 09:45PM
Re: Issues with converting update command to trigger
1073
July 03, 2020 02:53AM
994
July 03, 2020 07:17AM
1140
July 03, 2020 10:43AM
976
July 03, 2020 07:46PM
1167
July 15, 2020 05:33AM
1063
July 15, 2020 10:33AM
1082
July 15, 2020 11:02AM
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.