mysql 存储过程 循环插入

 drop procedure if exists sp1;
    delimiter //
    create procedure sp1()
    begin
        declare a int;
        set a = 1;
        l1:loop  

INSERT INTO user (ADDTIME,deleteStatus,availableBalance,freezeBlance,integral,PASSWORD,userName,userRole)

VALUES('2015-09-07',0,'0.00','0.00','20','e10adc3949ba59abbe56e057f20f883e',concat('zhangsan',a),'BUYER');

-- 注意用 concat('zhangsan',a)  拼接

        -- select a;
        if a=100 then
        leave l1;
        end if;

        set a = a+1;

        end loop;
    end //
    delimiter ;