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
>
>
