Using Two Timestamp Columns in One Table MySQL

On Technology

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. :)

Share

Unknown

DSefa is a blog that's dedicated to bringing you high quality health, lifestyle tutorial and resources on different categories. It's main forus on user experience.