: RE: to track the changes in database mySQL
Hi Satya,
You might like to look at triggers here
http://dev.mysql.com/doc/refman/5.0/en/triggers.html You can set a trigger
to go off at any of the events you have noted below. This would allow you to
log the userid and any other relevant information
From: Jimmy Guerrero [mailto:[EMAIL PROTECTED]
Sent: Tue 12/13/2005 6:44 PM
To: 'Logan, David (SST - Adelaide)'; Satyanarayana_Kesani; mysql@lists.mysql.com
Subject: RE: to track the changes in database mySQL
Hello,
Something to keep in the back of your mind
: Tuesday, December 13, 2005 7:28 AM
To: Jimmy Guerrero; Logan, David (SST - Adelaide); mysql@lists.mysql.com
Subject: RE: to track the changes in database mySQL
Thanks Jimmy,
I would like to get one thing clarified from you is: Am I able to create a
binary log (may be some other log) to know the changes
Hi all,
I got this mail Id from mySQL lists.I would like to request you for one help.
Actually I need to track the changes(UPDATE,INSERT,DELETE and others) done on
the database in mySQL by different users. I need to know which user has done
what changes . I am using mySQL 5.0.16-nt.
I would like
: to track the changes in database mySQL
Hi all,
I got this mail Id from mySQL lists.I would like to request you for one
help.
Actually I need to track the changes(UPDATE,INSERT,DELETE and others)
done on the database in mySQL by different users. I need to know which
user has done what changes . I