delimiter // create procedure mess ( vtitle varchar(50),vcontent varchar(1000) ) begin if trim(vtitle) != '' then insert into message values(vtitle,vcontent) ; end if; end; //
/*不用在声明declare vtitle varchar(50) delimiter // create procedure mess(vtitle varchar(50),vcontent varchar(1000)) begin if trim(vtitle)!='' then insert into message values(vtitle,vcontent); end if; end; //
create procedure mess ( vtitle varchar(50),vcontent varchar(1000) )
begin
if trim(vtitle) != '' then
insert into message values(vtitle,vcontent) ;
end if;
end;
//
delimiter //
create procedure mess(vtitle varchar(50),vcontent varchar(1000))
begin
if trim(vtitle)!='' then
insert into message values(vtitle,vcontent);
end if;
end;
//