MySQL: Column automaticly current time of insert

Question

I am creating a new table, and I would like each row to have a column that is equal to the time that the row is inserted into the table. Is there a way to do this in the create table statement or do I have to do this in my insert statement?

Answer 1

This should work:

CREATE TABLE table1 (
  timeStampColumn TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

Answer 2

Something like this when creating the table.

CREATE TABLE t1 (
  insert_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);