Code: Select all
DELIMITER //
CREATE PROCEDURE InsertUserData(IN uEmail VARCHAR(300), IN uPass VARCHAR(60), IN uName TEXT)
BEGIN
INSERT INTO user (email, pass, name)
VALUE (uEmail, uPass, uName); //How do I get it so that it will enter null for uName if no name was given as a parameter?
END //
DELIMITER ;Thanks.