Convert SQL Server Stored Procedure to MySQL Stored Procedure

i'm trying to create a small website so i need a registrion page i saw mudassar ahmed khan tutorial http://www.aspsnippets.com/Articles/Simple-User-Registration-Form-Example-in-ASPNet.aspx i have visual studio 2010 and my database is MySQL with phpmyadmin. but after coding the run time it's show a error. after a logtime googling i was found the error with the stored procedure in a SQL database my problum is i need to convert this sql stored procedure to MySQL... 

thx 

CREATE PROCEDURE [dbo].[Insert_User]
      @Username NVARCHAR(20),
      @Password NVARCHAR(20),
      @Email NVARCHAR(30)
AS
BEGIN
      SET NOCOUNT ON;
      IF EXISTS(SELECT UserId FROM Users WHERE Username = @Username)
      BEGIN
            SELECT -1 -- Username exists.
      END
      ELSE IF EXISTS(SELECT UserId FROM Users WHERE Email = @Email)
      BEGIN
            SELECT -2 -- Email exists.
      END
      ELSE
      BEGIN
            INSERT INTO [Users]
                     ([Username]
                     ,[Password]
                     ,[Email]
                     ,[CreatedDate])
            VALUES
                     (@Username
                     ,@Password
                     ,@Email
                     ,GETDATE())
           
            SELECT SCOPE_IDENTITY() -- UserId                 
     END
END