15 messages in com.mysql.lists.mysqlRE: mysql LOAD DATA INFILE
FromSent OnAttachments
Mike At Spy08 Aug 2003 12:34 
Donald Tyler08 Aug 2003 12:41 
Jay Blanchard08 Aug 2003 12:57 
Mike At Spy08 Aug 2003 12:58 
Donald Tyler08 Aug 2003 13:06 
Donald Tyler08 Aug 2003 13:08 
Jay Blanchard08 Aug 2003 13:08 
Mike At Spy08 Aug 2003 13:09 
Jay Blanchard08 Aug 2003 13:14 
Mike At Spy08 Aug 2003 13:19 
Mike At Spy08 Aug 2003 13:23 
Donald Tyler08 Aug 2003 13:29 
Mike At Spy08 Aug 2003 13:39 
Jay Blanchard08 Aug 2003 13:39 
Hans van Harten08 Aug 2003 15:24 
Subject:RE: mysql LOAD DATA INFILE
From:Mike At Spy (spyc@spyproductions.com)
Date:08/08/2003 01:19:07 PM
List:com.mysql.lists.mysql

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:jay.@niicommunications.com] Sent: Friday, August 08, 2003 4:08 PM To: Mike At Spy; Donald Tyler; mys@lists.mysql.com 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'