MySQL timestamp function

[PureDrive]

Hi, I know that mysql has some kind of a timestamp function but I am not 100% sure on how to use it. What I need is mysql to insert a new timestamp everytime I add a row to a specific table (I have a field called timestamp). How can I do that? Thanks

[NogDog]

Define the column as follows in your table definition:

column_name TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

(Note that if for some reason you have two TIMESTAMP type columns in a table, the above default/update attributes will only work with the first such column in the table.)

See http://dev.mysql.com/doc/refman/5.0/en/timestamp.html for more info.