mysql语句之-循环插入数据

---循环插入数据
create PROCEDURE test11(in zy varchar(20),in n int)
begin
DECLARE i int DEFAULT 1;
set @csql=concat('create table if not exists myuser',' (username varchar(10),password varchar(20),czy varchar(20));');
PREPARE create_stmt from @csql;
EXECUTE create_stmt;
if n>=1 and n<=9999 then
repeat
insert into myuser values(concat(zy,i),'123456','wo');
set i=i+1;
until i>n
end repeat;
end if;
end;

call test11('test',200);