A data trigger problem I insert in a list but a list associated with the other insert two identical data


This is my trigger:
DELIMITER $$

USE ` sensebot_outbound_db ` $$

DROP the TRIGGER/*! 50032 IF the EXISTS */` rosterinfo_insert_trigger ` $$

The CREATE
/*! 50017 DEFINER='senseext' @ '%' */
The TRIGGER ` rosterinfo_insert_trigger ` AFTER INSERT ON ` t_roster_info `
FOR EACH ROW BEGIN
INSERT INTO sensebot_info_external. ` plum_activity `
(id, firstName, lastName, gender, rosterName, activityName, callId, callStarttime, callEndtime,

The result, the resultCode contactNum, identifyId callTimes, callAnswerTime, callEndType, contactId, batchId)
VALUES
(NEW. Id, NEW firstname, NEW, lastname, NEW, sex, NEW. ActivityName, NEW, templateName, NEW. CallId, NEW. MakeCallTime, NEW. CallEndTime,

NEW callResult, NEW. The resultCode, NEW phoneNum1, NULL, NEW. CallRound, NEW. CallAnswerTime, NULL, NEW. JobId, NEW. BatchName);
The END;
$$

DELIMITER.

Consult everybody a great god

CodePudding user response:

Just testing this is the case, a data or test is the situation

CodePudding user response:

The test is so