Triggers in MySQL
@king99-bh2V1z
•
Oct 23, 2024
Oct 23, 2024
1.0K
Hi ,
Please can some body pinpoint exact difference between Statement Level Trigger and Row level trigger , please explain using some very simple example in both cases ?
1) How does UPDATE,INSERT Operation work in both of these type of triggers(Please
give some example).
2) What is exactly AFTER INSERT ON Table_name , does it mean after inserting some values
in trigger we fire this trigger ?
Please while explaining row level and statement level trigger give a simple example ,
thanks !!
3)
Please can some body pinpoint exact difference between Statement Level Trigger and Row level trigger , please explain using some very simple example in both cases ?
1) How does UPDATE,INSERT Operation work in both of these type of triggers(Please
give some example).
2) What is exactly AFTER INSERT ON Table_name , does it mean after inserting some values
in trigger we fire this trigger ?
Please while explaining row level and statement level trigger give a simple example ,
thanks !!
3)