MySQL trigger trigger for each row

The For each row is affected, and the trigger executes, called a row-level trigger. In Oracle triggers, line-level triggers and statement-level triggers, which do not write for each row, are executed only once, regardless of how many rows are affected. MySQL does not support statement triggers, so you must write for each row;

Actual Operation verification:

#触发器test5: DELIMITER $ $CREATE TRIGGER test5afterupdateon goodsfor each rowbegin  INSERT into ' Ord ' VALUES (1, 2, 2); end$$

MySQL only supports row-level triggers, which affect how many rows are executed.

MySQL trigger trigger for each row