Re: Issues with converting update command to trigger

[Peter Brawley]

A Trigger can't issue an Insert or Update on the table for which it's defined (because it could loop forever).

Is this what you mean?

CREATE TRIGGER add_desc AFTER 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;