basic_stored_procedure.sql

来自「php源码 php源码参考」· SQL 代码 · 共 15 行

# Basic stored procedure example

delimiter //

create procedure total_orders (out total float)
begin
 select sum(amount) into total from orders;
end
//

delimiter ;