mysql小技巧

来源：互联网发布：java 乱码中文为问号编辑：程序博客网时间：2024/05/22 02:08

显示重复的：

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;

0 0