Sonam Chauhan wrote:
>
> Is it possible to add additional query-specific information to the MySQL update log
> ?
>
> e.g.:
> ----------LOG EXCERPT------------------------
> # User: jj-332 Time: 2000-10-20-22:32
> insert into users set user="ass", ccode = "ass";
>
> # User: jj-323 Time: 2000-10-20-22:32
> insert into users set user="ass", ccode = "ewtkwj";
>
> # User: jj-344 Time: 2000-10-20-22:32
> insert into users set user="ass", ccode = "ewtkwj";
> ----------/LOG EXCERPT------------------------
>
> This essentially would work as an audit trail.
>
> It would need to pick up additional parameters from the client
> (eg: authenticated webserver user)
> The mySQL server would then add these params to the update log
>
> Could you cc: me on all replies? I'm not subscribed to all 3 lists.
>
> Regards,
> Sonam Chauhan
>
> Electronic Commerce
> Corporate Express Australia Ltd.
> Phone: +61-2-9335-0725 Fax: +61-2-9335-0753
This information is available in the binary log in the latest 3.23 version. You
will need to run mysqlbinlog to see it.
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <sasha@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
