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:
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 mysql cluster setup with 2 nodes. I would like to log all
updates for a certain, only updates, not inserts, is it possible?
would i be able to tell when it was updated and from what IP address
the update came from?
coz i have an issue wherein a certain table is being updated but i
could not tell where or when. thanks in advanced.
Regards,
Ron
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.392 / Virus Database: 270.13.34/2268 - Release Date: 07/28/09 06:00:00
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org