Using SCOPE_IDENTITY in MySQL Procedure

I am trying to create a MYSQL Procedure for my ASP net VB website but it keeps on failing,

please advise me on the issue

CREATE PROCEDURE `Insert_User` ( Username NVARCHAR(20), Password NVARCHAR(20), Email NVARCHAR(30) ) 
BEGIN 
    IF EXISTS(SELECT UserId FROM Users WHERE Username = Username) then 
        SELECT -1 
    IF EXISTS(SELECT UserId FROM Users WHERE Email = Email) then 
        SELECT -2 
    ELSE 
    BEGIN 
        INSERT INTO Users (Username, Password, Email, CreatedDate) VALUES (Username, Password, Email, GETDATE()) 
        SELECT SCOPE_IDENTITY() 
END;