Many Queries are allowed or Not allowed in Trigger?

Question

Many Queries are allowed or Not allowed in Trigger?

 

Answer 1

Multiple insert/update statements inside trigger?

trigger_stmt is the statement to execute when the trigger activates. If you want to execute multiple statements, use the BEGIN ... END compound statement construct. This also enables you to use the same statements that are allowable within stored routines

CREATE TRIGGER testref BEFORE INSERT ON test1
FOR EACH ROW BEGIN

INSERT INTO test2 SET a2 = NEW.a1;

DELETE FROM test3 WHERE a3 = NEW.a1;

UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;

END;

Answer 2

I don't get Many Queries means what but you can write multiple quiries inside the trigger