mysql创建存储过程,插入一百万数据
1、先创建一个用户表:
2、存储过程如下:
BEGIN
DECLARE username VARCHAR(60);
DECLARE userpwd VARCHAR(150);
DECLARE id VARCHAR(120);
DECLARE i INT DEFAULT 1;
WHILE i <= 1000000 DO
SET username = CONCAT('test', i);
SET userpwd = '123456';
SET id = i;
INSERT INTO `user`
VALUES(id,
username,
userpwd
);
SET i=i+1;
END WHILE;
END
3、运行后效果