循环向数据库添加数据

来源：互联网发布：网络不给力是什么意思编辑：程序博客网时间：2024/04/29 04:17

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)

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

0 0