My SQL函数

mac2026-06-17  6

Select fun_variable('rr1','123','5555') ;调用 语句: CREATE FUNCTION fun_variable() RETURNS int(20) BEGIN DECLARE msg VARCHAR(20); if not exists (SELECT * FROM class WHERE `name`=name1) then Insert into class(`name`,`number`) values(name1,number) ; RETURN msg=1; else update class set `number`=newname where `name`=name1; RETURN msg=0; end if; END

 

最新回复(0)