Re: How to do a large template query?

[Warren Young]

On Jan 26, 2010, at 11:58 PM, Adam Nielsen wrote:

> I'm writing a program to import some data into a MySQL database.  I guessed that the
> most efficient way of doing this was to use template queries

LOAD DATA INFILE is probably the most efficient way:

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

> It looks like this is because it can only take up to 25 parameters, but the table I
> am importing into has 40 fields.  Is there any way I can work around this limit?

http://tangentsoft.net/mysql++/doc/html/userman/configuration.html#max-columns