DROP PROCEDURE `pharm_update_store`;
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `pharm_update_store`(IN `in_selling_price` FLOAT(11), IN `in_expiry_date` DATE, IN `in_drug_name` VARCHAR(100), IN `in_item_code` VARCHAR(100), IN `in_store` VARCHAR(100), IN `in_facilityId` VARCHAR(100), IN `in_balance` INT)
update pharm_store set selling_price=in_selling_price,balance=in_balance WHERE expiry_date=in_expiry_date and drug_name=in_drug_name and item_code=in_item_code and store=in_store and facilityId=in_facilityId$$
DELIMITER ;