The general syntax of CREATE TRIGGER is :
CREATE TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_statement
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