Question

SqlServer的存储过程如何写成MySQL的存储过程，跪求！

有一个SqlServer的存储过程，由于对MySQL不是很熟悉，不知道如何写成MySQL的存储过程，求助！SqlServer的存储过程如下：
ALTER PROCEDURE Insert_U(
@UNo varchar(30),
@FunctionID int,
@UStopTime datetime
)
as
begin
if Exists(Select * From UserBehav Where UNo=@UNo and FunctionID = @FunctionID)
UPDATE UserBehav
SET UStopTime= @UStopTime
Where UNo=@UNo and FunctionID = @FunctionID
ELSE

INSERT INTO UserBehav (UNo, FunctionID,UStopTime)
VALUES(@UBMNo, @FunctionID,@UStopTime)
end

Answer 1

懒人，sorry