1.时间列选用timestamp类型,默认:CURRENT_TOMESTAMP;
2.编辑器编辑:
CREATE TABLE 'user'(
'userid' INT(11) PRIMARY KEY AUTO_INCREMENT,
'username' VARCHAR(20) NOT NULL,
'usertime' TIMESTAMP NULL DEFAULTCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
1.时间列选用timestamp类型,默认:CURRENT_TOMESTAMP;
2.编辑器编辑:
CREATE TABLE 'user'(
'userid' INT(11) PRIMARY KEY AUTO_INCREMENT,
'username' VARCHAR(20) NOT NULL,
'usertime' TIMESTAMP NULL DEFAULTCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)