插入和更新时默认值为当前时间,字段不能用Datetime类型,需要用timestamp类型,
建表时的写法为
`InsertTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
DROP TABLE IF EXISTS `obj_Test`;
CREATE TABLE `obj_Test` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, ,
`InsertTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`ReasonCode` smallint(2) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;