存储过程IF

种子之家

于 2012-08-20 10:06:11 发布

阅读量553

点赞数

CC 4.0 BY-SA版权

分类专栏： MySql 文章标签：存储 insert table

本文链接：https://blog.youkuaiyun.com/seeds_home/article/details/7885160

MySql 专栏收录该内容

41 篇文章

订阅专栏

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 |
+------+
*/