Hi,
Would something like this make it so that every time there was a new row
inserted on TEST, a row with the new values was inserted on LOG_TABLE? I
am not sure if you can reference NEW.id and all the NEW values directly
and send them in a trigger... Thanks...
CREATE TRIGGER test.data_table_au
AFTER UPDATE ON test.data_table
FOR EACH ROW
BEGIN
INSERT INTO log_table
(id_data, old_d1, new_d1, old_d2, new_d2, kind_of_change, ts)
VALUES
(new.id, old.d1, new.d1, old.d2, new.d2, 'update', now());
END
And could I go ahead and update two tables in the same trigger or am I
better off making the second trigger after update on the second table?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
