Mass Insert? - Earl Miles - com.mysql.lists.plusplus

4 messages in com.mysql.lists.plusplusMass Insert?

From	Sent On	Attachments
Earl Miles	03 Sep 2004 13:09
Steffen Schumacher	04 Sep 2004 02:30
Warren Young	07 Sep 2004 05:45
Warren Young	07 Sep 2004 06:06

Subject:	Mass Insert?
From:	Earl Miles (mer...@logrus.com)
Date:	09/03/2004 01:09:36 PM
List:	com.mysql.lists.plusplus

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.