MySQL Insert date log

Question

I am trying to find out when something was added to a database I maintain but the script that adds the date was working.

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

Answer 1

Something like this?

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

Answer 2

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