Multiple record Insert limit

2005-02-16 Thread Ed Reed
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

Re: Multiple record Insert limit

2005-02-16 Thread SGreen
Ed Reed [EMAIL PROTECTED] wrote on 02/16/2005 02:13:40 PM: 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

Re: Multiple record Insert limit

2005-02-16 Thread Ed Reed
That did it. Thanks for the quick response! [EMAIL PROTECTED] 2/16/05 11:19 AM Ed Reed [EMAIL PROTECTED] wrote on 02/16/2005 02:13:40 PM: 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,