显示重复的:
select productID,count(*) as count from ali.ali_product group by productID having count>1;
关闭更新安全
SQL_SAFE_UPDATES = 0;
CREATE TABLE `ali_dispatch_tasks` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`patchID` int(12) NOT NULL COMMENT '任务批次ID,递增,1,2,3,4',
`categoryID` varchar(256) NOT NULL COMMENT '类目ID',
`state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态(0:未开始;1:任务已派送;2:正在执行;3:执行完毕;4:执行错误)',
`serverID` varchar(20) NOT NULL DEFAULT '0' COMMENT '执行任务的服务器ID',
-- `productAmount` varchar(256) DEFAULT NULL COMMENT '包含产品数量',
-- `productAmountSuccess` varchar(256) DEFAULT NULL COMMENT '执行成功数',
`dispatchTime` datetime DEFAULT NULL COMMENT '任务派送时间',
`startHandleTime` datetime DEFAULT NULL COMMENT '开始执行时间',
`endHandleTime` datetime DEFAULT NULL COMMENT '执行完毕时间',
-- `createTime` datetime DEFAULT NULL,
-- `lastUpdateTime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4;
insert into ali_dispatch_tasks(patchID,categoryID,state,serverID,dispatchTime,startHandleTime,endHandleTime)
values(1,20032232,0,'192.168.21.2',curtime(),curtime(),curtime());
select * from ali_dispatch_tasks;