UPDATE `guardian` SET `serial_usr`='1798', `gender_grd`='MALE' WHERE `serial_grd`='2338';

UPDATE `USER` SET `status_usr`='INACTIVE' WHERE `serial_usr`='307';
UPDATE `USER` SET `serial_grd`='2338' WHERE `serial_usr`='1798';

DELETE FROM `USER_PROFILE` WHERE `serial_usr`='307' and`serial_prf`='2';

INSERT INTO `USER_PROFILE` (`serial_usr`, `serial_prf`, `status_upr`) VALUES ('1798', '2', 'ACTIVE');

DELETE FROM `USER` WHERE `serial_usr`='307';
