INSERT INTO `import_temptable` (row_id,tran_id,lastupdate,rowstatus,rowdata_org,rowdata_modified,rowdata_status,sql_command,insert_status) VALUES ('62,34,2019-09-05 12:20:32,Success,'school_name'=>'CGS','program_name'=>'CGS',,'school_name'=>'CGS','program_name'=>'CGS',,Pass,INSERT INTO school(school_name) SELECT 'CGS' WHERE NOT EXISTS( SELECT * FROM school WHERE school_name = 'CGS' );;; INSERT INTO program (program_school, program_name) SELECT school_id, 'CGS' FROM school WHERE school_name = 'CGS',Import');
INSERT INTO `import_temptable` (row_id,tran_id,lastupdate,rowstatus,rowdata_org,rowdata_modified,rowdata_status,sql_command,insert_status) VALUES ('63,34,2019-09-05 12:20:32,Success,'school_name'=>'CGS','program_name'=>'ETU',,'school_name'=>'CGS','program_name'=>'ETU',,Pass,INSERT INTO school(school_name) SELECT 'CGS' WHERE NOT EXISTS( SELECT * FROM school WHERE school_name = 'CGS' );;; INSERT INTO program (program_school, program_name) SELECT school_id, 'ETU' FROM school WHERE school_name = 'CGS',Import');
INSERT INTO `import_temptable` (row_id,tran_id,lastupdate,rowstatus,rowdata_org,rowdata_modified,rowdata_status,sql_command,insert_status) VALUES ('64,34,2019-09-05 12:20:32,Success,'school_name'=>'CET','program_name'=>'CE',,'school_name'=>'CET','program_name'=>'CE',,Pass,INSERT INTO school(school_name) SELECT 'CET' WHERE NOT EXISTS( SELECT * FROM school WHERE school_name = 'CET' );;; INSERT INTO program (program_school, program_name) SELECT school_id, 'CE' FROM school WHERE school_name = 'CET',Import');
