I agree. A loop is the easiest way to do it, but Chris did ask for alternatives. We once built a system that had to import 10s of thousands of records, obviously too much for an insert loop. We did it with shell scripts and it worked fine.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Stein Sent: Wednesday, December 18, 2002 11:33 AM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Inserting multiple records I've always found the loop to be pretty fast even with 100's of records. -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: "David Shelley" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Wed, 18 Dec 2002 11:21:50 -0500 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: RE: Witango-Talk: Inserting multiple records > > Chris, > > You can't directly insert an array into a db table. > You may be able to write the array out to a file and use a database IMPORT > command to load it into a table. I doubt that the ODBC driver supports an > IMPORT command but you might be able to call it from a stored procedure, > external action or shell script. However the overhead of doing this may be > such that it would be faster to loop through the array and do INSERTs, > unless the array is very large. > > Oh wait, you said 'an easy way'. OK never mind. > > Dave Shelley > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Millet > Sent: Wednesday, December 18, 2002 10:42 AM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Inserting multiple records > > > Is there an easy way to insert multiple records into a database without > using a loop? It seems DirectDBMS would work since MySQL will insert many > rows at a one time from other tables and files using the INSERT...SELECT > statement, but I'm not certain how it would work using an array. > > Chris ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
