|
|
I'm able to execute the following in the after impoert event
ie
DELETE test_answer FROM test_answer LEFT JOIN answer_key ON test_answer.publication_id = answer_key.Pub_ID AND test_answer.Question# = answer_key.Question# WHERE answer_key.Question#IS NULL;
and
TRUNCATE TABLE upload_250;
but the following one with UNION is not showing any error, but no record added to the table?? any idea?
Smith
my script is
$result = ("INSERT INTO test_answer (`publication_id`, `Student_ID`, `Question`, `Answer`)
(SELECT publication_id, Student_ID, '1', `1` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '2', `2` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '3', `3` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '4', `4` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '5', `5` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '6', `6` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '7', `7` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '8', `8` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '9', `9` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '10', `10` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '11', `11` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '12', `12` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '13', `13` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '14', `14` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '15', `15` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '16', `16` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '17', `17` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '18', `18` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '19', `19` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '20', `20` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '21', `21` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '22', `22` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '23', `23` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '24', `24` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '25', `25` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '26', `26` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '27', `27` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '28', `28` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '29', `29` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '30', `30` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '31', `31` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '32', `32` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '33', `33` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '34', `34` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '35', `35` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '36', `36` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '37', `37` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '38', `38` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '39', `39` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '40', `40` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '41', `41` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '42', `42` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '43', `43` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '44', `44` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '45', `45` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '46', `46` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '47', `47` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '48', `48` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '49', `49` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '50', `50` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '51', `51` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '52', `52` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '53', `53` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '54', `54` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '55', `55` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '56', `56` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '57', `57` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '58', `58` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '59', `59` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '60', `60` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '61', `61` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '62', `62` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '63', `63` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '64', `64` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '65', `65` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '66', `66` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '67', `67` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '68', `68` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '69', `69` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '70', `70` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '71', `71` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '72', `72` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '73', `73` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '74', `74` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '75', `75` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '76', `76` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '77', `77` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '78', `78` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '79', `79` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '80', `80` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '81', `81` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '82', `82` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '83', `83` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '84', `84` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '85', `85` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '86', `86` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '87', `87` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '88', `88` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '89', `89` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '90', `90` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '91', `91` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '92', `92` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '93', `93` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '94', `94` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '95', `95` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '96', `96` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '97', `97` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '98', `98` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '99', `99` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '100', `100` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '101', `101` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '102', `102` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '103', `103` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '104', `104` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '105', `105` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '106', `106` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '107', `107` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '108', `108` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '109', `109` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '110', `110` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '111', `111` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '112', `112` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '113', `113` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '114', `114` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '115', `115` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '116', `116` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '117', `117` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '118', `118` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '119', `119` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '120', `120` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '121', `121` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '122', `122` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '123', `123` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '124', `124` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '125', `125` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '126', `126` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '127', `127` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '128', `128` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '129', `129` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '130', `130` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '131', `131` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '132', `132` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '133', `133` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '134', `134` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '135', `135` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '136', `136` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '137', `137` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '138', `138` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '139', `139` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '140', `140` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '141', `141` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '142', `142` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '143', `143` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '144', `144` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '145', `145` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '146', `146` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '147', `147` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '148', `148` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '149', `149` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '150', `150` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '151', `151` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '152', `152` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '153', `153` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '154', `154` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '155', `155` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '156', `156` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '157', `157` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '158', `158` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '159', `159` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '160', `160` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '161', `161` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '162', `162` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '163', `163` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '164', `164` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '165', `165` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '166', `166` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '167', `167` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '168', `168` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '169', `169` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '170', `170` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '171', `171` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '172', `172` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '173', `173` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '174', `174` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '175', `175` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '176', `176` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '177', `177` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '178', `178` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '179', `179` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '180', `180` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '181', `181` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '182', `182` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '183', `183` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '184', `184` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '185', `185` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '186', `186` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '187', `187` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '188', `188` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '189', `189` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '190', `190` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '191', `191` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '192', `192` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '193', `193` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '194', `194` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '195', `195` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '196', `196` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '197', `197` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '198', `198` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '199', `199` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '200', `200` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '201', `201` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '202', `202` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '203', `203` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '204', `204` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '205', `205` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '206', `206` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '207', `207` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '208', `208` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '209', `209` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '210', `210` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '211', `211` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '212', `212` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '213', `213` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '214', `214` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '215', `215` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '216', `216` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '217', `217` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '218', `218` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '219', `219` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '220', `220` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '221', `221` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '222', `222` FROM upload_250) UNION
(SELECT publication_id, Student_ID, '223', `223` FROM upload_250)") ;
CustomQuery($result);
I want to execute the following sql AfterImport is executed after import is finished, how to go about?? regards Smith INSERT IGNORE INTO test_answer (publication_id, Student_ID, Question#, Answer) (SELECT publication_id, Student_ID, "1", 1 FROM upload_250) UNION (SELECT publication_id, Student_ID, "2", 2 FROM upload_250) UNION (SELECT publication_id, Student_ID, "3", 3 FROM upload_250) UNION (SELECT publication_id, Student_ID, "4", 4 FROM upload_250) UNION (SELECT publication_id, Student_ID, "5", 5 FROM upload_250) UNION (SELECT publication_id, Student_ID, "6", 6 FROM upload_250) UNION (SELECT publication_id, Student_ID, "7", 7 FROM upload_250) UNION (SELECT publication_id, Student_ID, "8", 8 FROM upload_250) UNION (SELECT publication_id, Student_ID, "9", 9 FROM upload_250) UNION (SELECT publication_id, Student_ID, "10", 10 FROM upload_250) UNION (SELECT publication_id, Student_ID, "11", 11 FROM upload_250) UNION (SELECT publication_id, Student_ID, "12", 12 FROM upload_250) UNION (SELECT publication_id, Student_ID, "13", 13 FROM upload_250) UNION (SELECT publication_id, Student_ID, "14", 14 FROM upload_250) UNION (SELECT publication_id, Student_ID, "15", 15 FROM upload_250) UNION (SELECT publication_id, Student_ID, "16", 16 FROM upload_250) UNION (SELECT publication_id, Student_ID, "17", 17 FROM upload_250) UNION (SELECT publication_id, Student_ID, "18", 18 FROM upload_250) UNION (SELECT publication_id, Student_ID, "19", 19 FROM upload_250) UNION (SELECT publication_id, Student_ID, "20", 20 FROM upload_250) UNION (SELECT publication_id, Student_ID, "21", 21 FROM upload_250) UNION (SELECT publication_id, Student_ID, "22", 22 FROM upload_250) UNION (SELECT publication_id, Student_ID, "23", 23 FROM upload_250); DELETE test_answer FROM test_answer LEFT JOIN answer_key ON test_answer.publication_id = answer_key.Pub_ID AND test_answer. Question# = answer_key. Question# WHERE answer_key. Question#IS NULL; TRUNCATE TABLE upload_250; |