CrazyEngineers
CrazyEngineers

  • Triggers in MySQL

    king99

    Member

    Updated: Oct 23, 2024
    Views: 983
    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)
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • PraveenKumar Purushothaman

    Member • 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
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register