Triggers in MySQL
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)
Replies
-
PraveenKumar PurushothamanIn 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
You are reading an archived discussion.
Related Posts
For race car team, the process costs as little as one-fifth the amount of traditional methods
FRANKFURT – 12th May 2011 — (NASDAQ: SSYS) Stratasys today announced that its Dimension...
Hello friends,
SAE update for June 2011 is now available. Please check out.
SAE Update - June 2011 - (1)
There is some view gaining ground that there may be a possibility of over educating oneself in technical fields. Even as far back as the late 1960s journals were writing...
For those interested:
Bangalore AWS 101 Cloud Computing Seminar - May 25
Quote:
Embedded devices are beginning to look a lot like desktop computers, as customers demand graphical interfaces, high-speed communications, multimedia, and full integration with Internet-delivered data and services. With these...