数据库存储过程造数据
# 先执行存储过程
CREATE PROCEDURE wp_user1(in n int)
BEGIN
declare seq varchar(50);
while n>0 DO
set seq := CONCAT('wp-',n);
insert into wp_user(id,name,age,adds) values(seq,'王朋','18','北京通州');
if n%1000=0 then
commit;
end if;
set n:=n-1;
end while;
END
# 这里是调用存储过程(插入一百万数据)
call wp_user1(1000000);
select * from wp_user where name = ‘王朋’
select count(*) from wp_user