List:General Discussion« Previous MessageNext Message »
From:Ed Reed Date:February 16 2005 8:13pm
Subject:Multiple record Insert limit
View as plain text  
Can anyone tell me the limit for the number of records that can be
inserted in a single call?
 
I'm trying to insert multiple records like this,
 
INSERT INTO t1 (f1, f2, f3, f4) VALUES
("test", 1, "some data", "Done"),
("testing", 21, "some more data", "Still Done"),("tested", 50, "no more
data", "Not Done"),("tester", 201, "Lots of data", "Finished");
 
This works when I've done 10 records but fails when I do 30000. The
error I get when it fails is 
[MySQL][ODBC 3.51 Driver][mysqld-4.1.7-nt]MySQL server has gone away.
So what's the max number that I can insert in a single statement?
 
Thanks!




Thread
Multiple record Insert limitEd Reed16 Feb
  • Re: Multiple record Insert limitSGreen16 Feb
Re: Multiple record Insert limitEd Reed17 Feb