MySql循环添加数据

最新推荐文章于 2025-05-01 18:31:59 发布

IT界的渣

最新推荐文章于 2025-05-01 18:31:59 发布

阅读量9.4k

点赞数

分类专栏： mysql 文章标签： mysql 数据

本文链接：https://blog.csdn.net/qq_34523482/article/details/77834669

版权

mysql 专栏收录该内容

1 篇文章

订阅专栏

create procedure test_two1()
     begin
        declare i int default 0;
       while i < 3000 do
            INSERT into tbl_test VALUES(i,'AAAAA','BBB','asdasd','asdasdsad','asdasdasd','asdasdasd','asdasdasd','asdasdsad','asdasdasdasdsad','564564a6s4da4sd','asdasd','asdalilil','zxczxc','zxcxczxc','zxczxc','zxczxc','zxczxczxc','asdasdxczxc','asdasdasd','asdasdasd');
            set i = i + 1;
        end while;
    end #

call test_two1();