RE: to track the changes in database mySQL

2005-12-13 Thread Jimmy Guerrero
ROTECTED] Sent: 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 k

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 m

RE: to track the changes in database mySQL

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

RE: to track the changes in database mySQL

2005-12-12 Thread Logan, David (SST - Adelaide)
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 you need. Regards David Logan Database Admin