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 PDT 2002; root:xnu/xnu-201.42.3.obj~1/RELEASE_PPC Power Macintosh powerpc Distro: MacOS 10.1.5 MySQL version: 3.23.51 On Thursday, September 19, 2002, at 06:55 PM, Chris Tucker wrote: > I'm having some trouble with a sizable (but certainly not huge) > multi-row insert statement. I can successfully execute the query with > up to 7365 rows, but any more and it fails -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php