Convert firebird trigger to mysql
lazarus / 16-Databases

----------------------------------------------------------------------
andersonscinfo · 2020-04-24 21:29

Hello, I don't know if here would be the correct location, maybe a
specific language forum, but even so I will try here first, I use
firebird and to make a trigger where I could handle insert, update and
delete in the same trigger would do so in firebird:
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SET TERM ^
;CREATE TRIGGER AP$TRIGGER_ERP_ITEM FOR ERP_ITEM ACTIVEAFTER INSERT OR
UPDATE OR DELETE POSITION 100AS BEGIN IF (inserting OR updating) THEN
BEGIN  .............. END IF (deleting) THEN BEGIN
 ..................END^SET TERM ; ^  
now i need to do this with mysql, but from what i realized i have to
make a trigger for each thing, one to insert another for update and
another for delete, is that correct? would anyone know another way to
do this?

Att.

----------------------------------------------------------------------
Zvoni · 2020-04-27 07:36

Quote from: andersonscinfo on April 24, 2020, 11:29:40 pmnow i need to
do this with mysql, but from what i realized i have to make a trigger
for each thing, one to insert another for update and another for
delete, is that correct?
Correct. One Trigger for each Action.

----------------------------------------------------------------------
andersonscinfo · 2020-04-27 10:17

OK thank you.