Audit Trail, database triggers?

[dmccabe]

i have asked this before I think, but it was a long time ago.

 

i am creating a database for work and I need to create an audit trail of who did what.

 

Is there anyway to set up triggers on a mySQL database so that when a field is update it captures certain information in to another table in the database?

[Mchl]

http://dev.mysql.com/doc/refman/5.0/en/triggers.html

[redarrow]

i worked it out na na na lol.

 

example from mchi link very nice!

 

drop tables a,b;

create table a(i int);

create table b(n int default 0);

insert into b values(0);

 

create trigger ainsert before insert on a for each row

update b set n=n+new.i;

 

insert into a values(1);

select * from b;