-- Table "pnodetail" DDL
CREATE TABLE `pnodetail` (
`id` varchar(100) NOT NULL,
`flag` varchar(2) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`pho` varchar(100) DEFAULT NULL,
[color=red]`updatetime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,[/color]
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
这样当更新表时,updatetime会设置为当前时间
CREATE TABLE `pnodetail` (
`id` varchar(100) NOT NULL,
`flag` varchar(2) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`pho` varchar(100) DEFAULT NULL,
[color=red]`updatetime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,[/color]
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
这样当更新表时,updatetime会设置为当前时间