MySql循环语句

	drop procedure if exists test_insert;
	DELIMITER ;;
	CREATE PROCEDURE test_insert ()  
	BEGIN  

	DECLARE i INT DEFAULT 1;
	  
	WHILE i<1000
	DO  
	UPDATE `syp2p`.`cus_accountseq` SET `customer_id`='14865160105557'     WHERE `seq_id`= i;
	SET i=i+1;  
	END WHILE ;  
	commit;  
	  
	END;;  
	  
	CALL test_insert();