List:MySQL++« Previous MessageNext Message »
From:Steffen Schumacher Date:September 4 2004 9:31am
Subject:Re: Mass Insert?
View as plain text  
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=1
> 
Thread
Mass Insert?Earl Miles3 Sep
  • Re: Mass Insert?Steffen Schumacher4 Sep
  • Re: Mass Insert?Warren Young7 Sep
    • Re: Mass Insert?Warren Young7 Sep