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"?
Each updated row, as per documentation:
" It can be BEFORE or AFTER to indicate that the trigger activates before or
after each row to be modified. "
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
