kill端口-更新sql-添加字段

所加的字段

ALTER TABLE `distribution_task`
ADD COLUMN `update_time` datetime(0) NOT NULL COMMENT '任务更新时间';

ALTER TABLE `distribution_task`
ADD COLUMN `classify` int(10) NOT NULL COMMENT '任务状态记录情况(待揽件(1)、待派件(2)、揽件成功(3)、揽件失败(4)、派件成功(5)、派件失败(6))';

ALTER TABLE `distribution_task`
ADD COLUMN `delivery_reason` varchar(255) NULL COMMENT '任务派件原因';

ALTER TABLE `distribution_task`
ADD COLUMN `package_reason` varchar(255) NULL COMMENT '任务揽件原因';

_________________________________________________________________________________
alter table `distribution_task` ADD COLUMN `update_time` datetime not null default current_timestamp
_________________________________________________________________________________

 

查询端口   kill-----端口

netstat -ano |findstr 查询某一特定的端口

taskkill /f /t /im 查杀某一端口或者端口名字

 

 

UPDATE distribution_task SET delivery_reason = NULL, package_reason =NULL, update_time = '2019-11-20 00:00:00' , classify = 1 WHERE STATUS = 1;

UPDATE distribution_task SET delivery_reason = NULL, package_reason =NULL, update_time = '2019-11-20 00:00:00', classify = 2 WHERE STATUS =2;

UPDATE distribution_task SET delivery_reason = NULL, package_reason =NULL , update_time = '2019-11-20 00:00:00', classify = 3 WHERE STATUS =3 AND business_type = 0;

UPDATE distribution_task SET delivery_reason = NULL ,`package_reason`= NULL ,update_time = '2019-11-20 00:00:00', classify = 5 WHERE STATUS =3 AND (business_type = 1 OR business_type = 2)