how to log insert/update query's for a specific table in mysql 5

Question

Hi, does anyone knows if it is possible to log all insert/update query's for a specific table in mysql 5?

We got multiple applications querying the same database, so implementation of this in the data access layer (two many apps) is quite unrealistic, would be much easy if we can just turn a switch on in the configuration file in the database. I realize we could log all query's but that would be quite a performance hit.

Answer 1

This thing is called "audit trail". Google should give you a fair amount of answers.