This topic is locked

Copy record to Archive

10/26/2008 10:15:41 AM
PHPRunner General questions
buddy author

I have a table that I need to copy and insert a record into another table any time a change is made. I know that I should use the "After record Updated feature" and have seen similar solutions on this forum although what I would like to do is copy the entire record (all fields) without having to program each individual field.
I'm sure this is fairly simple although it's beyond me. Any help would be appreciated.

M
mustafa 10/26/2008

Hello,
You can use a trigger to do it directly inside the database.
For MySQL:

MySQL 5.0 Reference Manual - CREATE TRIGGER Syntax