MySQL-存储过程批量插入数据

批量插入数据

BEGIN    
	DECLARE i INT; 
	SET AUTOCOMMIT = 0;
	SET i = 0;  
	WHILE i < 10000 DO  
	INSERT INTO `sys_user` VALUES (NULL, 'wangjz', i, 'password', '1', '1', '17091367497', '732472723@qq.com', '1', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
	SET i = i + 1;  
	END WHILE;
	COMMIT;  
	SET AUTOCOMMIT = 1;
END