Hi All,

Below I have given a stored procedure for User Registration in MS Sql

/******Stored Procedure MS Sql Starts Here*******/

CREATE PROC InsertRegDetails
(
@UserId numeric(9) ,
@FName varchar(50),
@LName varchar(50),
@Email varchar(100),
@DepartmentName varchar(50)
)
AS
BEGIN TRANSACTION

INSERT INTO LoginTable VALUES(@UserId,@FName,@LName,@Email)

INSERT INTO DeptTable
VALUES(@UserId,@DepartmentName)

IF @@ERROR<>0
BEGIN
ROLLBACK
RAISERROR('ERROR IN REGISTRATION',16,1)
RETURN
END
COMMIT
GO

/******Stored Procedure for MS Sql Ends Here*******/

I need it to convert into MySql. How I Can do it , Please Help me.


Thanks in Advance
Manoj