List:General Discussion« Previous MessageNext Message »
From:Mihamina Rakotomandimby Date:July 13 2010 9:37am
Subject:Triggers and "FOR EACH ROW"
View as plain text  
Manao ahoana, Hello, Bonjour,

I just read several documentation on MySQL triggers.
The way to create triggers is:
CREATE TRIGGER t21_au
 BEFORE UPDATE ON t22
 FOR EACH ROW
 BEGIN
 // ...
 END;

The trigger I want is only on UPDATE.

Is "FOR EACH ROW" referring to "each existing row in the table", or to
"each UPDATEd row"?

Misaotra, Thanks, Merci.

-- 

       Architecte Informatique chez Blueline/Gulfsat:
    Administration Systeme, Recherche & Developpement
                                    +261 34 56 000 19
Thread
Triggers and "FOR EACH ROW"Mihamina Rakotomandimby13 Jul
  • Re: Triggers and "FOR EACH ROW"Martijn Tonies13 Jul