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!
