| 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 Rakotomandimby | 13 Jul |
| • Re: Triggers and "FOR EACH ROW" | Martijn Tonies | 13 Jul |
