以下语句在查询中完成
语句:
CREATE PROCEDURE tttt(name1 varchar(10),number varchar(11),newname varchar(10))
BEGIN
if not exists (SELECT * FROM class WHERE `name`=name1) then
Insert into class(`name`,`number`) values(name1,number) ;
else
update class set `number`=newname where `name`=name1;
end if;
END
CALL tttt('rr1','123','5555');赋值