Many Queries are allowed or Not allowed in Trigger?

Question

Munesh Sharma · Answer

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 ;

Vithal Wadje · Answer

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