drop table if exists t;
create table t (s1 int);
insert into t values (5);
select * from t;
-- --------------------------------------------------
drop procedure if exists p12;
delimiter //
create procedure p12 (in parameter1 int)
begin
declare variable1 int;
set variable1 = parameter1 + 1;
if variable1 = 0 then
insert into t values (17);
end if;
if parameter1 = 0 then
update t set s1 = s1 + 1;
else
update t set s1 = s1 + 2;
end if;
end; //
delimiter ;
call p12(5);
select * from t;
/*
+------+
| s1 |
+------+
| 7 |
+------+
*/
call p12(-1);
select * from t;
/*
+------+
| s1 |
+------+
| 9 |
| 19 |
+------+
*/