drop table if exists t;
create table t (s1 int);
insert into t values (5);
select * from t;
-- --------------------------------------------------
drop procedure if exists p13;
delimiter //
create procedure p13 (in parameter1 int)
begin
declare variable1 int;
set variable1 = parameter1 + 1;
case variable1
when 0 then insert into t values (17);
when 1 then insert into t values (18);
else insert into t values (19);
end case;
end; //
delimiter ;
call p13(0);
select * from t;
/*
+------+
| s1 |
+------+
| 5 |
| 18 |
+------+
*/
call p13(null);
select * from t;
/*
+------+
| s1 |
+------+
| 5 |
| 18 |
| 19 |
+------+
*/
存储过程:case
最新推荐文章于 2024-07-27 21:51:16 发布