Monday, April 28, 2014

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 ;