Mysql循环insert 语句

DROP PROCEDURE IF EXISTS proc_initData;

DELIMITER $

CREATE PROCEDURE proc_initData()

BEGIN

DECLARE i INT DEFAULT 1;

WHILE i<=349 DO

insert into xxxxx(store_id, assoc_id, recycle_flg, create_by, create_time, update_by, update_time, exclusive_version_no)VALUES(i, 1, 0, ‘’, NOW(), ‘’, NOW(), 1);

SET i = i+1;

END WHILE;

END $

CALL proc_initData();