hi all,

i have a table (not my design) with a lot of fields and users have access
to insert/update/delete record from this table. is there a way that mysql
can log all transactions who change what on this table??? or do i have to
create a seperate table to keep track the changes?

for example: someone changed the price from 2.00 to 2.50 on price

this needs to be done for the purpose of auditing.

i found some docs on mysql.com, but mostly for query log & server log.


thanks,
t. hiep