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