uhhh.....there are only two fields in the table, but I'll give it a whirl. :)
As for Donald's advice: it gave me access denied for user. :\ -Mike > -----Original Message----- > From: Jay Blanchard [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 4:08 PM > To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED] > Subject: RE: mysql LOAD DATA INFILE > > > [snip] > 70050;451 > 70322;451 > > > LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS > > TERMINATED BY ';' LINES TERMINATED BY '\r\n' > > [/snip] > [/snip] > > I am going to recommend that you specify which columns the data goes > into > > > LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one`(foo, > bar) FIELDS > > TERMINATED BY ';' LINES TERMINATED BY '\r\n' > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]