When creating a trigger in MySQL, are there any alternatives to FOR EACH ROW? -


I would like to create an update after triggering that runs only once, even if multiple rows have been updated.

In MySQL 5.0, all triggers are for each line - that is,

However, see the following.

Trigger is active for each row, which has been inserted, updated or deleted.


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -