MYSQL Procedure

[CNP]

Not sure where do I find the code button, I dont see it

Hi eapiater,

For SCOPE IDENTITY use LAST_INSERT_ID in MySql.

Refer below procedure.

SQL

DELIMITER $$
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;
	ELSEIF EXISTS (SELECT UserId FROM Users WHERE Email = Email) THEN
		SELECT -2;
	ELSE 
		INSERT INTO Users (Username, Password, Email, CreatedDate) VALUES (Username, Password, Email, GETDATE());
		SELECT LAST_INSERT_ID();
	END IF;
END $$