Triggers in MySQL

king99

king99

@king99-bh2V1z Oct 23, 2024
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)

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

  • PraveenKumar Purushothaman

    PraveenKumar Purushothaman

    @praveenkumar-66Ze92 May 12, 2011

    In MySQL 5.0, all triggers are FOR EACH ROW—that is, the trigger is activated for each row that is inserted, updated, or deleted. MySQL 5.0 does not support triggers using FOR EACH STATEMENT.

    MySQL 5.0.2 introduced support for triggers. Some of the triggers MySQL supports are
    » Insert Trigger
    » Update Trigger
    » Delete Trigger