how can I insert two insert into a trigger

Question

how can I insert two insert into a trigger

Navigation

#1 by (2 votes)
#2 by (1 votes)

1

As I can do two insert in a trigger try that but it does not work for me, if I put a single insert if it pulls but in phpmyadmin

CREATE TRIGGER update_alumnos AFTER INSERT ON Alumnos
FOR EACH ROW BEGIN
    INSERT INTO Procesos VALUES (new.id,1,1)
    INSERT INTO Validar_residencia VALUES (new.id,0,'sin observaciones')
END

mysql phpmyadmin

asked by goku venz 06.06.2017 в 15:47

source

2 answers

2

Try changing your sentence this way:

DELIMITER |
CREATE TRIGGER update_alumnos AFTER INSERT ON Alumnos
FOR EACH ROW BEGIN
    INSERT INTO Procesos VALUES (new.id,1,1);
    INSERT INTO Validar_residencia VALUES (new.id,0,'sin observaciones');
END;
|
DELIMITER;

answered by 06.06.2017 в 16:12

Firebase notifications I can not install NetBeans in Windows 10

score 1 · Accepted Answer

I already solved it apparently had to put a delimiter

delimiter //

CREATE TRIGGER update_alumnos AFTER INSERT ON Alumnos
FOR EACH ROW BEGIN
INSERT INTO Procesos VALUES (new.id,1,1);
INSERT INTO Validar_residencia VALUES (new.id,0,'sin observaciones');
END;//

delimiter ;