学习笔记（8):MySQL数据库从入门到实战课-存储过程及基本使用

立即学习:https://edu.csdn.net/course/play/27328/370712?utm_source=blogtoedu

use mydb;

show tables;

delimiter //

create procedure my_sum(in a int,in b int ,out result int)

begin

set result = a + b;

end

//

delimiter;

call my_sum(10,20,@result);

select @result;

delimiter //

create procedure my_n_sum(in n int, out result int)

begin

 declare i int default 1;

 declare sum int default 0;

 while i<=n do

 set sum = sum + i;

 set i = i + 1;

 end while;

 set result = sum;

end;

//

delimiter ;

call my_n_sum(100,@result);

select @result;