How to Create a Stored Proc in MySQL
May 15th, 2008
I haven’t seen this very well and clearly documented, as far as passing parameters go. Here is a simple create user proc.
DELIMITER $$
DROP PROCEDURE IF EXISTS `portfoliomanager`.`createNewUser` $$
CREATE PROCEDURE `portfoliomanager`.`createNewUser` (IN username varchar(45),IN pass varchar(45))
BEGIN
INSERT INTO portfoliomanager.users (email,password) VALUES(username,pass);
END $$
DELIMITER ;
