MySQL Insert date log

I am trying to find out when something was added to a database I maintain b开发者_如何学Pythonut the script that adds the date was working.

Is there a way to retrieve the date of the original INSERT command?

Something like this?

http://dev.mysql.com/doc/refman/5.0/en/query-log.html

make a new table with the key of the table to watch create a after insert trigger that inserts a new line into the watchout table with the id and the time inserted