MySQL Forums
Forum List  »  Triggers

Re: Issues with converting update command to trigger
Posted by: Peter Brawley
Date: July 02, 2020 11:59AM

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;

Options: ReplyQuote




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.