Change the delimiter in mysql

To deploy the procedure via terminal in mysql you need to change the delimiter! So this is a sample step that you could follow to do it!

DELIMITER //

CREATE PROCEDURE ChangeInventory(in InventoryID INT, in Quantity INT) 

BEGIN 

UPDATE INVENTORY SET IN_QTY = Quantity WHERE IN_P_ID = InventoryID; 

END // 

DELIMITER ;