Re: Issues with converting update command to trigger

[Shawn Logan]

Error
SQL query: Documentation


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;
MySQL said: Documentation

#1362 - Updating of NEW row is not allowed in after trigger