mysql 存储过程批量新增数据

最新推荐文章于 2024-06-04 09:48:22 发布

不二有恒

最新推荐文章于 2024-06-04 09:48:22 发布

阅读量450

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/qq_40521919/article/details/107023757

版权

mysql 专栏收录该内容

5 篇文章

订阅专栏

CREATE PROCEDURE pro11(in count int)
BEGIN
    declare jump int DEFAULT count;
    WHILE jump>0 DO BEGIN
        DECLARE i INT DEFAULT 1;
        DECLARE c INT DEFAULT jump;
        IF c>10000 THEN
            SET c=10000;
        END IF;
        SET @sq=concat("INSERT INTO `open_platform_dev`.`anji_open_gateway_request_monitor`( `uuid`, `request_url`, `app_id`, `sign`, `timestamp`, `method`, `project_code`, `request_header`, `request_params`, `request_body`, `response_content`, `result`, `start_time`, `end_time`, `request_interval`, `create_by`, `create_time`, `update_by`, `update_time`, `version`)VALUES ('TEST-65', 'http', 'testApp', 'D03E7A91D8D6281D6DFD7C221032F789', '1592545503155', 'protobuf', 'task', '', '', NULL, '', '500', 1592545503161, 1592545505188, 2027, NULL, '2020-06-29 16:10:26', NULL, '2020-06-29 16:10:26', NULL) ");
        WHILE i<c DO
          SET @sq=concat(@sq,"  ,( 'TEST-65', 'http', 'testApp', 'D03E7A91D8D6281D6DFD7C221032F789', '1592545503155', 'protobuf','");
					SET @sq=concat(@sq, i);
					SET @sq=concat(@sq, " ','', '', NULL, '', '500', 1592545503161, 1592545505188, 2027, NULL, '2020-06-29 16:10:26', NULL, '2020-06-29 16:10:26', NULL)");
          SET i=i+1;
        END WHILE;
        SELECT @sq;
        PREPARE s FROM @sq;
        EXECUTE s;
        DEALLOCATE PREPARE s;
        SET jump=jump-c;
    END;
    END WHILE;
END

call pro11(2);
select count(1) from anji_open_gateway_request_monitor;  -- 123514

drop procedure if exists pro11 ;