- 创建无参存储过程:
delimiter $;
create procedure findSupplier();
begin
select * from supplier;
end
$
调用存储过程:
delimiter ;
call findSupplier;
2. 创建带参数的存储过程:
delimiter $;
create procedure findSupplierByID(IN id varchar(6))
begin
select * from supplier where sup_id=id;
end
$
调用存储过程:
delimiter ;
call findSupplierByID('Sup-01');