Re: Create stor procedure

[Peter Brawley]

You gorgot delimiter directives?

drop procedure if exists site_sp;
delimiter go
create procedure site_sp()
begin
  select count(*) from showsite;
end;
go
delimiter ;

But since the sproc has just one line of code, you can drop the begin-end, whereupon you can drop the delimiter too ...

drop procedure if exists site_sp;
create procedure site_sp()
select count(*) from showsite;

But then we have to ask, what problem are you trying to solve by putting this one line of code in an sproc?