RE: to track the changes in database mySQL

2005-12-13 Thread Jimmy Guerrero
: 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

RE: to track the changes in database mySQL

2005-12-13 Thread Satyanarayana_Kesani
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

RE: to track the changes in database mySQL

2005-12-13 Thread Jimmy Guerrero
: 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

to track the changes in database mySQL

2005-12-12 Thread Satyanarayana_Kesani
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

RE: to track the changes in database mySQL

2005-12-12 Thread Logan, David (SST - Adelaide)
: 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