RE: [PHP-DB] Re: backup of database record before update

Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion on the board here that MYSQL triggers were not so reliable and still somewhat problematic so I archive through the application. Just curious. -----Original Message----- From: Neil Smith [MVP, Digital media] [mailto:php@comatose.freeserve.co.uk] Sent: Tuesday, October 30, 2007 3:16 PM To: php-db@lists.php.net Cc: Ronald Wiplinger Subject: [PHP-DB] Re: backup of database record before update At 06:57 28/10/2007, you wrote: >Message-ID: <4724328C.90608@elmit.com> >Date: Sun, 28 Oct 2007 14:56:12 +0800 >From: Ronald Wiplinger <ronald@elmit.com> >I need some hints how to do that. Maybe there is a template or an >easy function available. > >I have a MySQL database with some tables. Everytime a table record >changes, I want also put the old record to a history database. >The history table and the original only differs that the key of the >original will be just a field in the backup, while the new key is >now the UNIX time stamp. > >How can I do that "easy"? "Easy" is to set a MySQL5 trigger which does the Insert on update : http://dev.mysql.com/doc/refman/5.0/en/triggers.html eg (from the manual page) : DELIMITER | CREATE TRIGGER testref BEFORE INSERT ON test1 FOR EACH ROW BEGIN INSERT INTO test2 SET a2 = NEW.a1; DELETE FROM test3 WHERE a3 = NEW.a1; UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1; END; | HTHCheers - Neil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php