最全MySQL8.0实战教程 14 MySQL的存储过程 14.5 流程控制【4 循环 - while】

今天药忘吃喽~ 2024-03-26 17:23 63阅读 0赞

#### 最全MySQL8.0实战教程 ####

#### 文章目录 ####

*   *   *  最全MySQL8.0实战教程
         *  14 MySQL的存储过程
         *   *  14.5 流程控制【4 循环 - while】
             *   *  14.5.7 格式
                 *  14.5.8 操作

[【黑马程序员MySQL知识精讲+mysql实战案例\_零基础mysql数据库入门到高级全套教程】 ][MySQL_mysql_mysql_]

#### 14 MySQL的存储过程 ####

##### 14.5 流程控制【4 循环 - while】 #####

###### 14.5.7 格式 ######

【标签:】while 循环条件 do
        循环体;
    end while【标签】;

###### 14.5.8 操作 ######

-- 创建测试表
    create table user (
        uid int primary key,
        username varchar (50),
        password varchar (50)
    );

![在这里插入图片描述][77956c9fdd694055970ffe7ca6a8008a.png_pic_center]

-- -------存储过程-while
    delimiter $$
    create procedure proc16_while1(in insertcount int)
    begin
        declare i int default 1;
        label:while i<=insertcount do
            insert into user(uid,username,password) values(i,concat('user-',i),'123456');
            set i=i+1;
        end while label;
    end $$
    delimiter ;
     
    call proc16_while1(10);

![在这里插入图片描述][9f81eda25a1a47969c4b95ae14d35e52.png_pic_center]

看看表

![在这里插入图片描述][3d481657db7f4705a1f3f5424c8cee6e.png_pic_center]

没问题

-- -------存储过程-while + leave
    truncate table user;
    delimiter $$
    create procedure proc16_while2(in insertcount int)
    begin
        declare i int default 1;
        label:while i<=insertcount do
            insert into user(uid,username,`password`) values(i,concat('user-',i),'123456');
            if i=5 then leave label;
            end if;
            set i=i+1;
        end while label;
    end $$
    delimiter ;
     
    call proc16_while2(10);

![在这里插入图片描述][6fc2048017b14e21ba1faa3c69035a28.png_pic_center]

看看表

![在这里插入图片描述][e54da2b823f94eeaae4587bb81b84817.png_pic_center]

-- -------存储过程-while+iterate
    truncate table user;
    delimiter $$
    create procedure proc16_while3(in insertcount int)
    begin
        declare i int default 1;
        label:while i<=insertcount do
            set i=i+1;
            if i=5 then iterate label;
            end if;
            insert into user(uid,username,`password`) values(i,concat('user-',i),'123456');
        end while label;
    end $$
    delimiter ;
    
    call proc16_while3(10);

![在这里插入图片描述][921652386c0f46d5a313ae93672ee023.png_pic_center]

看看表

![在这里插入图片描述][cbe5b791b6e74dd191b95059621545db.png_pic_center]

没问题。

[MySQL_mysql_mysql_]: https://www.bilibili.com/video/BV1iF411z7Pu
[77956c9fdd694055970ffe7ca6a8008a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/2bade55e0f1c4675bc544867dd696e3b.png
[9f81eda25a1a47969c4b95ae14d35e52.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/3d29fc87cdd74d6baa0d4b2bbffd9102.png
[3d481657db7f4705a1f3f5424c8cee6e.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/fca4e0b4796743e7a111345535781609.png
[6fc2048017b14e21ba1faa3c69035a28.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/52a74dc0befa47a5aa0624e3caed643b.png
[e54da2b823f94eeaae4587bb81b84817.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/4f2273c49f03457f80d3c729bb3d3a32.png
[921652386c0f46d5a313ae93672ee023.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/ab513dd7807c4020ba70e7fbcea3f284.png
[cbe5b791b6e74dd191b95059621545db.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/4d53fb5fff18467ba3f09a90027748d3.png