循环向数据库添加数据

BEGIN

declare n bigint ;

declare i BIGINT;

declare myid VARCHAR(100);

declare  card_number VARCHAR(100);

declare user_id varchar(100);

declare phone_number varchar(100);

declare email varchar(100);

declare bank_account varchar(100);

set n=1;

while (n<1000000)

DO

set i=2000000+n;

set myid=SUBSTR(i,2);

set card_number=CONCAT('321001199306',myid);

set user_id=CONCAT('001004',myid);

set phone_number=CONCAT('13952',myid);

set email=CONCAT('100',myid,'@qq.com');

set bank_account=CONCAT('2345422',myid);

insert into ea_employees

     (EMPLOYEES_ID,USER_NAME,CARD_NUMBER,ENTERPRISE_NO,EMPLOYEE_NO,USER_ID,SEX,

     PHONE_NUMBER,EMAIL,BANK_NAME,BANK_VALUE,BANK_ACCOUNT,

     PROVINCE,PROVINCE_NAME,CITY,CITY_NAME,BANK_OFFICE,DEP_ID,

     ENTRY_TIME,CREATE_TM,CREATE_BY,MODIFY_TM,MODIFY_BY)

     values

     (myid,'mao',card_number,'001004',myid,user_id,1,phone_number,email,'NANJING',

     '南京银行',bank_account,'Jiangsu','江苏','nanjing','南京','南京支行','001004002',

     '2013-09-18 00:00:00','2014-03-06 14:50:43','开发人员','2014-03-06 18:02:29','开发人员');

set n=n+1;

end while;

END