原以为在Mysql中的存储过程这么写:
create procedure myp9(in cid char)
begin
select * from custcopy where cust_id=cid;
end
正确的sql:
delimiter &&
create procedure myp9(in cid char)
begin
select * from custcopy where cust_id=cid;
end &&
delimiter ;
原以为在Mysql中的存储过程这么写:
create procedure myp9(in cid char)
begin
select * from custcopy where cust_id=cid;
end
正确的sql:
delimiter &&
create procedure myp9(in cid char)
begin
select * from custcopy where cust_id=cid;
end &&
delimiter ;