0
kicks
Trigger and number of rows affected
One of my frieds told me that INSERT trigger will not fire if no data are added to the main table. It is a mistake that some people think that triggers will not fire if no row is affected. Note that trigger is event based and not data based. Here is a proof that trigger fires eventhough no row is affected...