Re: Issues with converting update command to trigger

[Peter Brawley]

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.