循环插入测试数据脚本

沙发

drop procedure test_insert

create procedure test_insert()
begin
    declare n int;
    set n=1;
    while n<200000 do

        if n<100000 then
            insert into student(Id,Sno,Name,Age,State,DateTime) values(n,'201401010001',concat('杨昆',n),20,0,'2014-03-20');
        elseif n>=100000 then
            insert into student(Id,Sno,Name,Age,State,DateTime) values(n,'201401010002',concat('杨昆',n),21,1,'2014-03-20');
        end if;

        set n=n+1;

    end while;
end;

call test_insert();