Using Two Timestamp Columns in One Table MySQL

Using Two Timestamp Columns in One Table MySQL

By LN K - March 21, 2014

Using Two Timestamp Columns in One Table

According to http://dev.mysql.com/doc/refman/5.1/en/timestamp-initialization.html

CREATE TABLE t1 (
  ts1 TIMESTAMP DEFAULT 0,
  ts2 TIMESTAMP DEFAULT CURRENT_TIMESTAMP
                ON UPDATE CURRENT_TIMESTAMP);

INSERT INTO t1(ts1) VALUES (NOW());

Please left me a comment if you have any question. :) Thanks. :)