mysql存储过程循环语句简单例子
来源:互联网 发布:ubuntu 卸载软件 编辑:程序博客网 时间:2024/05/20 06:30
delimiter //
create procedure proc1(out s int)
begin
select count(*) from into s from mysql.users;
end;
//
call proc1(@s);
select @s;
create procedure pin(in p_in int)
begin
select p_in;
set p_in=2;
select p_in;
end;
//
set @p_in=1;
call pin(@p_in);
create procedure pout(out p_out int)
begin
select p_out;
set p_out=2;
select p_out;
end;
//
create procedure pinout( inout p_inout int)
begin
select p_inout;
set p_inout=2;
select p_inout;
end;
//
create procedure pt3(n1 int)
begin
set @x=0;
repeat set @x=@x+1;
insert into t3 values(@x);
until @x > n1
end repeat;
end;
//
create procedure proc2(in p1 int)
begin
declare var int;
set var=p1+1;
if var=1 then instert into t values(11);
end if;
if var=2 then insert into t values(22);
else insert into t values(33);
end if;
end;
//
create procedure proc3(in p1 int)
begin
declare var int;
set var p1+1;
case var
when 1 then insert into t values(17);
when 2 then insert into t values(18);
else insert into t values(19);
end case;
end;
//
create procedure proc4()
begin
declare var int;
set var=0;
while var<6 do
insert into t value(var);
set var=var+1;
end while;
end;
//
create procedure proc5()
begin
declare v int;
set v=0;
repeat
insert into t values(v);
set v=v+1;
until v>=5
end repeat;
end;
//
create procefure proc6()
begin
declare v int;
st v=0;
LOOP_LABLE:loop
insert into t values(v);
set v=v+1;
if v>=5 then
leave LOOP_LABLE;
end if
end loop;
end;
//
create procedure proc7()
begin
declare v int default 0;
LOOP_LABLE:loop
set v=v+1;
if v<10 then iterate LOOP_LABLE;
elseif v>20 then LEAVE LOOP_LABLE;
else select 'v is between 10 and 20';
end if
end loop LOOP_LABLE;
end;
create procedure proc1(out s int)
begin
select count(*) from into s from mysql.users;
end;
//
call proc1(@s);
select @s;
create procedure pin(in p_in int)
begin
select p_in;
set p_in=2;
select p_in;
end;
//
set @p_in=1;
call pin(@p_in);
create procedure pout(out p_out int)
begin
select p_out;
set p_out=2;
select p_out;
end;
//
create procedure pinout( inout p_inout int)
begin
select p_inout;
set p_inout=2;
select p_inout;
end;
//
create procedure pt3(n1 int)
begin
set @x=0;
repeat set @x=@x+1;
insert into t3 values(@x);
until @x > n1
end repeat;
end;
//
create procedure proc2(in p1 int)
begin
declare var int;
set var=p1+1;
if var=1 then instert into t values(11);
end if;
if var=2 then insert into t values(22);
else insert into t values(33);
end if;
end;
//
create procedure proc3(in p1 int)
begin
declare var int;
set var p1+1;
case var
when 1 then insert into t values(17);
when 2 then insert into t values(18);
else insert into t values(19);
end case;
end;
//
create procedure proc4()
begin
declare var int;
set var=0;
while var<6 do
insert into t value(var);
set var=var+1;
end while;
end;
//
create procedure proc5()
begin
declare v int;
set v=0;
repeat
insert into t values(v);
set v=v+1;
until v>=5
end repeat;
end;
//
create procefure proc6()
begin
declare v int;
st v=0;
LOOP_LABLE:loop
insert into t values(v);
set v=v+1;
if v>=5 then
leave LOOP_LABLE;
end if
end loop;
end;
//
create procedure proc7()
begin
declare v int default 0;
LOOP_LABLE:loop
set v=v+1;
if v<10 then iterate LOOP_LABLE;
elseif v>20 then LEAVE LOOP_LABLE;
else select 'v is between 10 and 20';
end if
end loop LOOP_LABLE;
end;
//
declare ;
0 0
- mysql存储过程循环语句简单例子
- mysql存储过程简单例子
- mysql 存储过程while循环插入语句
- mysql 最简单的存储过程例子
- 【MySQL】存储过程、游标、循环简单实例
- mysql的存储过程中的语句if case 循环语句
- mysql存储过程 例子 游标cursor 循环嵌套 事物
- mysql存储过程 例子 游标cursor 循环嵌套 事物
- mysql存储过程 例子 游标cursor 循环嵌套 事物
- 存储过程简单例子
- 存储过程简单例子
- MySQL 存储过程例子
- mysql存储过程例子
- mysql 存储过程例子
- mysql 存储过程例子
- mysql 存储过程循环
- MySQL存储过程中使用 WHILE 循环语句的用法
- MySQL 存储过程中使用 WHILE 循环语句
- OpenDaylight Hydrogen版本应用SampleTap研究(一)
- 6个用于大数据分析的最好工具
- 【Java编程思想】(1)初始化与清理
- CVE-2015-3202 exploit demo
- java hashCode
- mysql存储过程循环语句简单例子
- 比较两个DataTable内容是否相等,先是比数量,数量相等就比内容
- zookeeper原理(转)
- 基于ORACLE数据库的循环建表及循环创建存储过程的SQL语句实现
- CGGeometry
- Nginx 反向代理、负载均衡、页面缓存、URL重写及读写分离详解
- 黑马程序员---Java 装饰设计模式
- ajax
- BC 2015年百度之星程序设计大赛 - 初赛(1)(矩形面积-旋转卡壳)