Defenseload

DELIMITER $$


DROP PROCEDURE IF EXISTS `updateAllOtherInsurance`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `updateAllOtherInsurance`(pIDs VARCHAR(1000))
 BEGIN
 
 DELETE FROM patientinsuranceelgihistory WHERE FIND_IN_SET(patientInsID, pIDs) > 0;

 END$$

DELIMITER ;