REPLACE into resp_mail(channel_id,push_seq,resp_seq,status_resp,desc_resp
,time_resp)

select channel_id,push_seq,resp_seq,status_resp,desc_resp
,'20190401 09:54:01' from resp_mail where id=46;

DROP TABLE IF EXISTS `report_mail`;
CREATE TABLE `report_mail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
  `push_seq` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送序号',
  `resp_seq` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'resp序号',
  `report_seq` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报告序号',
  `status_report` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报告返回码',
  `desc_report` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报告返回码描述',
  `time_report` varchar(23) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报告时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_report_seq`(`report_seq`) USING BTREE,
  INDEX `index_resp_seq`(`resp_seq`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 132 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '邮件发送报告' ROW_FORMAT = Compact;

INSERT INTO report_mail ( push_seq, resp_seq, report_seq, status_report, desc_report, time_report )
VALUES
	( null
	,'RESP-00922','REPORT-00922','0','DELIVRD','20190401 16:37:01' ) 
	ON DUPLICATE KEY UPDATE resp_seq ='RESP-00922',
	status_report ='0',
	desc_report ='DELIVRD',
	time_report ='20190401 16:28:01';