From: Steffen Schumacher
Date: September 4 2004 9:31am
Subject: Re: Mass Insert?
List-Archive: http://lists.mysql.com/plusplus/3455
Message-Id: <20040904093118.GA78287@freesbee.wheel.dk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On 03.09.2004 13:09:58 +0000, Earl Miles wrote:
> I'm trying to figure out how to do an insert with multiple VALUES 
> statements using MySQL++ and the basic things I've tried don't work; I'm 
> sure I've missed the obvious one, but I'm not very familiar with the 
> package yet.
> 
> To be clear, the functionality I'm trying to do is equivalent to this:
> 
> INSERT INTO table (a, b, c) VALUES (1, 2, 3), (4, 5, 6), (7, 8, 9) ...
> 
> I'm interested in this for performance reasons, as I expect to have a 
> very large number of inserts to do and I would like to combine as many 
> of them as possible in order to save write time.
> 

If you have an environment which can tolerate it securitywise, you can use 
the load local infile.. But I don't know if that is an option for you?
> -- 
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:    
> http://lists.mysql.com/plusplus?unsub=steffen@stripped
>