ALTER TABLE `security_guard`
ADD COLUMN `serviceEndTime`  varchar(16) NULL COMMENT '服务结束时间' AFTER `serviceStartTime`;


ALTER TABLE `temp_batch_security_guard_import`
ADD COLUMN `serviceStartTime`  varchar(16) NULL COMMENT '服务开始时间',
ADD COLUMN `serviceEndTime`  varchar(16) NULL COMMENT '服务结束时间';


update security_guard
set serviceEndTime = DATE_ADD(serviceStartTime,INTERVAL 3 YEAR)
where active=true
and serviceEndTime is null
and serviceStartTime is not null;