It's just a standard text file; here is a piece of it: 70321;451 70050;451 70322;451 70323;451 70051;451 67026;451 70053;451 67420;451 67419;451 70451;451 70452;451 67820;451 72080;451 72081;451 72082;451 72083;451 20148;452 39761;452 20147;452 20112;452
Just lines like this: a little over 15,000 of them. :) -Mike > -----Original Message----- > From: Jay Blanchard [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 3:58 PM > To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED] > Subject: RE: mysql LOAD DATA INFILE > > > [snip] > Sorry, that is the error - my mistake. I am getting this: > > LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS > TERMINATED BY ';' LINES TERMINATED BY '\r\n' > [/snip] > > Mike, could we see just a bit of the php9GOwvw file...just out of > curiosity > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]