Re: TRIGGER

[Peter Brawley]

Given table Log ( UserName varchar(20), Action varchar(20), Date datetime), your MySQL update trigger would look like this ...

CREATE TRIGGER Watch AFTER UPDATE ON ORDERS AS
INSERT INTO Log(new.UserName, Action, Date) VALUES (USER(), 'Update', CURDATE());

As Barry suggests, see the MySQL manual page for Triggers.

But a log like that isn't an efficient audit trail---you're writing each column value twice! Mmore efficient: lose the orders table, emulate it with a View, and implement transaction state logic in insert/update/delete code for orders. see "Point-in-time architecture" at http://www.artfulsoftware.com/infotree/mysqltips.php .