执行创表语句:
DROP TABLE IF EXISTS `seller`;
CREATE TABLE `seller` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`phone` varchar(120) NOT NULL COMMENT '手机号',
`password` varchar(120) DEFAULT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`xvp_store_id` bigint(11) DEFAULT NULL COMMENT '小V铺的店铺id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86358 DEFAULT CHARSET=utf8 COMMENT='卖家账户信息';
错误代码: 1293
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause解决方法:
第一步、改变timestamp类型字段,只存在一个,另一个用datetime类型;
第二部、用触发器:
DROP TRIGGER IF EXISTS `update_seller_trigger`;
DELIMITER //
CREATE TRIGGER `update_seller_trigger` BEFORE UPDATE ON `seller`
FOR EACH ROW SET NEW.`update_time` = NOW()
//
DELIMITER ;
效果一样