Quer

USE `eschool_online_apps`;

DELETE FROM `school_payment_gateway_creds` WHERE `SchoolID`=9598;


INSERT
 INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Login_ID','332082');
INSERT INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Product_ID','SCHOOL');
INSERT INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Request_hash_key','1add7fb49853afc262');
INSERT
 INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Reponse_hash_key','340a5bf1cd496ed436');
INSERT
 INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Password','cb775a2d');
INSERT INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Request_Key','96BD882518455747E8DA32B43D9AA012');
INSERT
 INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Request_Salt','96BD882518455747E8DA32B43D9AA012');
INSERT
 INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Response_Key','63B7A41614CF18208DAE09E5AFFBB543');
INSERT
 INTO
`school_payment_gateway_creds`(`SchoolID`,`PGID`,`PG_creds_name`,`PG_creds_value`)
 VALUES (9598,(SELECT `PGID` FROM `school_payment_gateway` WHERE
UPPER(`PGNAME`)="ATOMNEW"),'Response_Salt','63B7A41614CF18208DAE09E5AFFBB543');

UPDATE `schools` SET `eSchoolPay`=1 WHERE `S_ID`=9598;