MySql批量插数据

最新在做产品的性能测试，写了个存储过程向数据库批量插入数据

 

 

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`CreateTestUsers`$$

CREATE DEFINER=`ipd`@`%` PROCEDURE `CreateTestUsers`()
BEGIN
	DECLARE v1 INT DEFAULT 500;
	DECLARE exec_sql VARCHAR(1024);
	WHILE v1 > 200 DO
	    SET v1 = v1 - 1;
	    SET exec_sql=
		CONCAT(' INSERT INTO test_sys_user SET '
			, ' sqn=(SELECT RAND()*100000000000000)'
			, ', account=', '\'b',v1 ,'\'' 
			, ', passwd=' ,'\'b',v1,'\'' 
			, ', isLdapUser=0'			
			);
	SET @SQL=exec_sql;
	PREPARE s1 FROM @SQL;
	EXECUTE s1;
	DEALLOCATE PREPARE s1;
	END WHILE;
END$$

DELIMITER ;