"ヾ(◍°∇°◍)ノ゙加油哟~","愿我们不负昭华,以梦为马!","愿我们历尽千帆,归来仍是少年!"

mysql批量插入数据的存储过程

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
DROP PROCEDURE IF EXISTS my_insert;
CREATE PROCEDURE my_insert()
BEGIN
   DECLARE n int DEFAULT 1;
        loopname:LOOP
             
INSERT INTO order_today VALUES (n, n, n+100, '2021-04-27 12:21:58', n, '测试', '2021-04-27 12:22:12', '2021-04-27 12:22:15');
     
            SET n=n+1;
        IF n=100000 THEN
            LEAVE loopname;
        END IF;
        END LOOP loopname;
END;
CALL my_insert();

  

posted @   深夜独行侠  阅读(168)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示