Well MySQL will see all the changes coming from a single user (the user who
the web site connects to the database as). You'll have to add your own
routines to log that info to a table or something...
Unless ofcourse, I'm missing something, which I doubt :)
----- Original Message -----
From: "Chris W" <2wsxdr5@stripped>
To: "MYSQL General List" <mysql@stripped>
Sent: Monday, August 21, 2006 9:02 PM
Subject: Audit trail
>I would like to create an audit trail for one table in my DB. Users will
>login to my web site and be able to enter and edit information, I want to
>keep a record of what changes are made by what user. These users will be
>web site users and not actual MySQL users. Is there an easy method in
>MySQL to do this, or do I just need to write code to track any changes as
>they are entered?
> Chris W
> Gift Giving Made Easy
> Get the gifts you want & give the gifts they want
> One stop wish list for any gift, from anywhere, for any occasion!
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1