Msqll批量生成数据脚本

BEGIN

DECLARE V_XZQHDM VARCHAR(50);
DECLARE V_JGDM  VARCHAR(250);
DECLARE V_YWSJ VARCHAR(50);
DECLARE V_ZXZ DECIMAL (11,3);
DECLARE V_LASTUPDATE VARCHAR(50);
DECLARE V_ZBID VARCHAR(50);
DECLARE i BIGINT;
DECLARE v_RHY VARCHAR(20);

SET i =1;
WHILE i< 10000 DO
      INSERT INTO yp_mzfx(XZQHDM,JGDM,YWSJ,ZXZ,LASTUPDATE,ZBID,RHY) VALUES(V_XZQHDM,V_JGDM,V_YWSJ,V_ZXZ,V_LASTUPDATE,V_ZBID,v_RHY);

SET V_XZQHDM =FLOOR(442000+RAND()*200);
SET V_JGDM ='G1917348544200011A1001';
set V_YWSJ =DATE(FROM_UNIXTIME(UNIX_TIMESTAMP('2017-01-01')+FLOOR(RAND()*(UNIX_TIMESTAMP('2019-12-30') - UNIX_TIMESTAMP('2017-01-01') + 1))));
SET V_ZXZ =FLOOR(5000+RAND()*10000);
SET V_LASTUPDATE=SYSDATE();
SET V_ZBID=FLOOR(1200+RAND()*1400);
SET v_RHY="1";
SET i=i+1;
END WHILE;
END