MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Acessing the subject row from a trigger...
Posted by: Bob Field
Date: July 12, 2006 02:32PM

In an update trigger, you can use the syntax OLD.colname to refer to the contents of a column in a row that is about to be updated. Then you can either INSERT or UPDATE that value into the corresponding column in the other table.

http://dev.mysql.com/doc/refman/5.0/en/using-triggers.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Acessing the subject row from a trigger...
2547
Scott Huey
July 12, 2006 01:27PM
Re: Acessing the subject row from a trigger...
1390
Bob Field
July 12, 2006 01:46PM
Re: Acessing the subject row from a trigger...
1942
Scott Huey
July 12, 2006 02:16PM
Re: Acessing the subject row from a trigger...
1817
Bob Field
July 12, 2006 02:32PM
Re: Acessing the subject row from a trigger...
1812
Scott Huey
July 12, 2006 04:26PM
Re: Acessing the subject row from a trigger...
1686
Bob Field
July 12, 2006 04:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.