MySQL: Column automatically current insert time

Question

I am creating a new table, and I would like each row to have a column equal to the time the row is inserted into the table. Is there a way to do this in the create table statement, or do I need 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 a table.

 CREATE TABLE t1 ( insert_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); 

Answer 3

The TIMESTAMP data type offers automatic initialization and updating to the current date and time (that is, the current timestamp). MORE

 TIMESTAMP 

Example

 CREATE TABLE t1 ( ts TIMESTAMP ); 

Answer 4

you can set the default value as NOW as

  CREATE TABLE example ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, data VARCHAR(140), created TIMESTAMP DEFAULT NOW() ); 

Answer 5

SQLFiddle demo

Automatic initialization and update for TIMESTAMP and DATETIME

 CREATE TABLE t1 ( id int, update_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );