> Why don't you use the load data command to import the data in to mysql?
> I've done this successfully for about 56,000 records. I currently don't
> have a larger data set, so that is definitely not a limit I hit.
The server I need to load data into is replicated: load data with a
local infile
Why don't you use the load data command to import the data in to mysql?
I've done this successfully for about 56,000 records. I currently don't
have a larger data set, so that is definitely not a limit I hit.
Server uname -a:
Darwin localhost 5.5 Darwin Kernel Version 5.5: Thu May 30 14:51:26 P
Chris,
Friday, September 20, 2002, 1:55:39 AM, you wrote:
CT> I'm having some trouble with a sizable (but certainly not huge)
CT> multi-row insert statement. I can successfully execute the query with
CT> up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has
CT> gone away). Mo
> Is there any way to insert more than one row at a time??? The data that
I
> have will change with each row, but is there a way to insert 900 rows
(with
> different values for each) all at once?
INSERT INTI VALUES (row1), (row 2), (row3) .
where rowN is a list of values for the row in