以下语句在查询中完成
语句： 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');赋值
