mysql if then

CREATE PROCEDURE userinfo_modify(
	IN id INT
	,IN loginid INT
	,IN levelid INT
	,IN	namestr	VARCHAR(50)
	,IN	tel		VARCHAR(50)
	,IN	account	VARCHAR(50)
)
BEGIN
set @lid=loginid;
set @lvid=levelid;
set @n=namestr;
set @t=tel;
set @a=account;
set @uid=id;
select @eid=IFNULL(loginid,0) from userinfo where loginid=@lid;

if (IFNULL(@eid,0)=0)
Then
Insert into userinfo(loginid,levelid,namestr,tel,account)
	VALUES(@lid,@lvid,@n,@t,@a);
select last_insert_id();
ELSE 
	update userinfo
		SET  loginid	=@lid
					,levelid=@lvid
					,namestr=@n
					,tel		=@t
					,account=@a
		where id=@uid;
END IF;
END

mysql if then

标签：