basic_stored_procedure.sql

《PHP和MySQL Web开发》(第三版) Source

# Basic stored procedure example

delimiter //

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

delimiter ;