1.创建自定义存储过程
https://www.cndba.cn/hbhe0316/article/22216
https://www.cndba.cn/hbhe0316/article/22216
DROP PROCEDURE if exists insert_t1;
DELIMITER //
CREATE PROCEDURE insert_t1(IN loop_times INT)
BEGIN
DECLARE var INT DEFAULT 0;
WHILE var < loop_times DO
INSERT INTO testdb.t1 VALUES (var,'aaa');
SET var = var + 1;
END WHILE;
END //
DELIMITER ;
2.条用存储过程https://www.cndba.cn/hbhe0316/article/22216https://www.cndba.cn/hbhe0316/article/22216
mysql> call insert_t1(50000000);
这样就可以在t1表中插入5000W行数据。
https://www.cndba.cn/hbhe0316/article/22216
https://www.cndba.cn/hbhe0316/article/22216
https://www.cndba.cn/hbhe0316/article/22216
https://www.cndba.cn/hbhe0316/article/22216
https://www.cndba.cn/hbhe0316/article/22216
https://www.cndba.cn/hbhe0316/article/22216
版权声明:本文为博主原创文章,未经博主允许不得转载。
MYSQL