Re: tracing table updates

2009-07-28 Thread Ron
Hi Peter, Thanks for your help. I now created a trigger that would do an insert on another table on what changes has been made to the other table. another question is, is it possible to get the host from where the update request came from from the trigger? Regards Ron Peter Brawley wrote:

Re: tracing table updates

2009-07-28 Thread Peter Brawley
Ron > I would like to log all updates for a certain, only updates, not inserts, is it possible? Sure. For a review of methods for various kinds of audit trails see "Audit Trails" Parts I & II at http://www.artfulsoftware.com/infotree/mysqltips.php. PB Ron wrote: Hi All, I have a m