DELIMITER $$
CREATE PROCEDURE `updateBookingCountProcedure`(IN `categoryId` VARCHAR(255), IN `bookingQuantity` INT)
BEGIN
    DECLARE tempCount INT;
    SET tempCount = 0;
    SELECT bookingCount INTO tempCount FROM category WHERE id = categoryId;

    UPDATE category
    SET bookingCount = tempCount + bookingQuantity WHERE id = categoryId;
END$$
DELIMITER ;