I have already tried the code from http://www.aspforums.net/Threads/252942/Convert-SQL-Server-Stored-Procedure-to-MySQL-Stored-Procedure/Replies/1#Replies
CREATE PROCEDURE Insert_User
(
IN _Username NVARCHAR(20),
IN _Password NVARCHAR(20),
IN _Email NVARCHAR(30)
)
BEGIN
IF EXISTS(SELECT UserId FROM Users WHERE Username = _Username;)
SELECT -1; -- Username exists.
ELSE IF EXISTS(SELECT UserId FROM Users WHERE Email = _Email;)
SELECT -2; -- Email exists.
ELSE
INSERT INTO [Users]
([Username]
,[Password]
,[Email]
,[CreatedDate])
VALUES
(_Username
,_Password
,_Email
,GETDATE());
SELECT LAST_INSERT_ID();
END IF;
END;
Keeps on getting error at line : 8