ERROR IN TRIGGER SQL BY MARIADB VERSION

1

I have inserted this trigger :

    DELIMITER //
    CREATE TRIGGER tr_updStockIngreso AFTER 
    INSERT ON detalle_ingreso
     FOR EACH ROW BEGIN
     UPDATE producto SET STOCK_PRODUCTO = STOCK_PRODUCTO + NEW.CANTIDAD_INGRESO 
     WHERE producto.ID_PRODUCTO = NEW.ID_PRODUCTO;
    END
    //

DELIMITER ;

but I get this error:

  

1235 - This version of MariaDB does not support 'multiple triggers with the same action time and event for one table' yet

    
asked by Joan 26.06.2017 в 05:18
source

1 answer

0

Verify that there are no more triggers in the table

tr_updStockIngreso

If there are no more triggers, make sure that, if you are updating an existing trigger, make a drop first.

In case you need two triggers simultaneously in the AFTER INSERT, you must combine them in one only.

    
answered by 26.06.2017 в 05:47