Using Two Timestamp Columns in One Table MySQL

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

Popular posts from this blog

npm refusing to install as a dependency of itself

How to call javascript functions from VB.NET and using WebBrowser Control