Comment
Jim
General Trigger form?,
June 17, 2010 at 10:53 PM
June 17, 2010 at 10:53 PM
You said,
/begin/
The general syntax of CREATE TRIGGER is :
CREATE TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_statement
/end/
But is this really true? Is it really true that a trigger can ONLY be created that will always loop thru ALL the rows in the table?
I find that hard to believe.
I don't know but my own expertise leads me to doubt this is true. I in fact am searching for how to update another table with selected data from the trigger table when an update to the trigger table happens.
View All Comments
/begin/
The general syntax of CREATE TRIGGER is :
CREATE TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_statement
/end/
But is this really true? Is it really true that a trigger can ONLY be created that will always loop thru ALL the rows in the table?
I find that hard to believe.
I don't know but my own expertise leads me to doubt this is true. I in fact am searching for how to update another table with selected data from the trigger table when an update to the trigger table happens.
View All Comments
Related Tutorial and Articles
