MySQL if Then

CREATE PROCEDURE userinfo_modify (in ID int,in loginid int,in levelid Int,innamestrvarchar (+), Intelvarchar (50), Inaccountvarchar ()) 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 [e-mail 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