List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:January 27 2010 10:57am
Subject:Re: How to do a large template query?
View as plain text  
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
Thread
How to do a large template query?Adam Nielsen27 Jan
  • Re: How to do a large template query?Warren Young27 Jan
    • Re: How to do a large template query?Adam Nielsen28 Jan
      • Re: How to do a large template query?Joel Fielder28 Jan
        • Re: How to do a large template query?Warren Young28 Jan
          • Re: How to do a large template query?Adam Nielsen29 Jan
            • Re: How to do a large template query?Joel Fielder29 Jan
              • Re: How to do a large template query?Joel Fielder29 Jan
              • Re: How to do a large template query?Adam Nielsen1 Feb
            • Re: How to do a large template query?Warren Young29 Jan
              • Re: How to do a large template query?Adam Nielsen1 Feb
                • Re: How to do a large template query?Warren Young1 Feb
                  • Re: How to do a large template query?Warren Young7 Feb
          • Re: How to do a large template query?Warren Young7 Feb