mysql-trigger2proc-insert.sql

DELIMITER //

CREATE PROCEDURE ProcSuma(IN nm1 INT, IN nm2 INT, OUT value INT)
BEGIN
SET value = nm1+nm2;
END; //

CREATE PROCEDURE ProcResta(IN nm1 INT, IN nm2 INT, OUT value INT)
BEGIN
SET value = nm1-nm2;
END; //

CREATE PROCEDURE ProcMultiplicacion(IN nm1 INT, IN nm2 INT, OUT value INT)
BEGIN
SET value = nm1*nm2;
END; //

CREATE PROCEDURE ProcDivision(IN nm1 INT, IN nm2 INT, OUT value FLOAT)
BEGIN
SET value = nm1/nm2;
END; //

CREATE PROCEDURE ProcInsertOP(IN n1 INT, IN n2 INT, OUT suma INT, OUT resta INT, OUT mult INT, OUT dividir FLOAT)
BEGIN
CALL ProcSuma(n1, n2, suma);
CALL ProcResta(n1, n2, resta);
CALL ProcMultiplicacion(n1, n2, mult);
CALL ProcDivision(n1, n2, dividir);
END; //

DELIMITER ;

DELIMITER //
CREATE TRIGGER make_operations
BEFORE INSERT
ON operaciones
FOR EACH ROW
BEGIN
CALL ProcInsertOP(new.num1, new.num2, @sum, @rest, @mult, @division);
SET new.rSuma = @sum;
SET new.rResta = @rest;
SET new.rMultiplicacion = @mult;
SET new.rDivision = @division;
END; //
DELIMITER ;