SqlServer存储过程转MySQL存储过程
SqlServer原存储过程:
USE ***
GO
/****** Object: StoredProcedure [dbo].[spb_ClubUserData_ChangeExperiencePoints] Script Date: 03/17/2016 17:05:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spb_ClubUserData_ChangeExperiencePoints]
(
@UserID int,
@ExperiencePoints int
)
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
if not exists (select * from spb_ClubUserDatas with (nolock) WHERE [UserID] = @UserID)
INSERT INTO spb_ClubUserDatas (UserID,ExperiencePoints)values(@UserID,@ExperiencePoints)
else
Update spb_ClubUserDatas set ExperiencePoints=ExperiencePoints+@ExperiencePoints where UserID=@UserID
转的MySQL存储过程:
BEGIN
#Routine body goes here...
set @UserID=UserID;
set @ExperiencePoints=ExperiencePoints;
if not exists (select * from spb_ClubUserDatas WHERE UserID = @UserID)
then
INSERT INTO spb_ClubUserDatas (UserID,ExperiencePoints)values(@UserID,@ExperiencePoints);
else
Update spb_ClubUserDatas set ExperiencePoints=ExperiencePoints+@ExperiencePoints where UserID=@;UserID
end if;
END;
我改的MySQL存储过程中要传的参数与字段相同,然后where后面的值就是相等的了,并不能起到筛选作用,这个需要怎么修改??如果我转的存储过程是错的,请大神指点一下