mysql if then

標籤：

CREATE PROCEDURE userinfo_modify(IN id INT,IN loginid INT,IN levelid INT,INnamestrVARCHAR(50),INtelVARCHAR(50),INaccountVARCHAR(50))BEGINset @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 [email protected];if (IFNULL(@eid,0)=0)ThenInsert into userinfo(loginid,levelid,namestr,tel,account)VALUES(@lid,@lvid,@n,@t,@a);select last_insert_id();ELSE update userinfoSET  loginid[email protected],[email protected],[email protected],tel[email protected],[email protected]where [email protected];END IF;END

　　

mysql if then