mysql时间戳自动更新
-- 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,
`updatetime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
这样当更新表时，updatetime会设置为当前时间