存储过程1:
CREATE DEFINER=`root`@`localhost` PROCEDURE `pr_add`(a int,b int)
begin
declare c int;
if a is null then
set a = 0;
end if;
if b is null then
set b = 0;
end if;
set c = a + b;
select c as sum;
end
操作流程:
输入两个值
最终结果:
---------------------------------------------------------------------------------------------------------------------------------------------
存储过程2
users表设计
SQL代码:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_name`()
BEGIN
#Routine body goes here...
declare n bigint;
set n = 201121029684;
while n <= 201121029694
do
insert into users(student_ID) values(n);
set n = n + 1;
end while;
END
运行结果: