Re: Issues with converting update command to trigger
create table telemetry_log(id int,device_id int,device_desc varchar(32) );
create table id_name_device(device_id int,device_desc varchar(32) );
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 );
Works in MySQL 5.7 and 8.0.
Subject
Views
Written By
Posted
1590
July 01, 2020 09:29AM
669
July 01, 2020 09:33AM
573
July 01, 2020 02:07PM
607
July 02, 2020 05:55AM
593
July 02, 2020 11:59AM
1012
July 02, 2020 07:10PM
638
July 02, 2020 09:45PM
622
July 03, 2020 02:53AM
Re: Issues with converting update command to trigger
600
July 03, 2020 07:17AM
610
July 03, 2020 10:43AM
575
July 03, 2020 07:46PM
613
July 15, 2020 05:33AM
632
July 15, 2020 10:33AM
626
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.