CREATE PROCEDURE insertuser1()
#设置循环变量
DECLARE i INT;
#循环变量赋值
SET i = 1;
WHILE i <=num DO
INSERT INTO iwebshop_user(username,PASSWORD) VALUES(CONCAT("dabai",1),"111111");
SET i = i+1;
END WHILE;
存储过程造数据
于 2022-08-12 15:51:46 首次发布
CREATE PROCEDURE insertuser1()
#设置循环变量
DECLARE i INT;
#循环变量赋值
SET i = 1;
WHILE i <=num DO
INSERT INTO iwebshop_user(username,PASSWORD) VALUES(CONCAT("dabai",1),"111111");
SET i = i+1;
END WHILE;