MySQL5.6版本后DATETIME类型字段可以设置默认值与自
2017-08-21 本文已影响0人
linweiyu21
CREATE TABLE t1 (
ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
参考
11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME
