-----Original Message-----
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: 09 August 2007 14:16
To: Gary Josack
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
Try:
|load data local infile '|/volumes/raider/aml.master.8.6.07.|csv'
into table test fields terminated by ',' enclosed by '"' lines
terminated by '\n' |ignore 1 lines
|(First, Last, Add1, Add2, City, State, Zip, XCode, Reason, Date);
If that doesn't work could you please provide more output from the
csv file in question?
|
The current load file command that I've been trying is:
load data local infile "/volumes/raider/aml.master.dos.csv" into
table test fields terminated by "," lines terminated by "" (First,
Last, Add1, Add2, City, State, Zip, XCode, Reason, Date);
I tried adding "\r\n" to the file and it didn't work, here is some of
the lines from my csv file:
First,Last,Add2,Add1,City,State,Zip,Date,Xcode,Reason
A. DREW,MILES,,1583 Jerome St,Holland,MI,49423-6703,,P,
Aaron,Davis,,14796 Creek Edge Dr,Holland,MI,49424,05/17/07,S,
Aaron,Kraai,,3710 88th Ave,Zeeland,MI,49464-9716,05/17/04,S,
Aaron,Shuck,,288 W 13th St,Holland,MI,49423-3452,04/28/03,,
Adam,Hecht,,177 Cambridge Ave,Holland,MI,49423,03/22/05,S,
ADE,VLIENSTRA,,304 W 30th St,Holland,MI,49423-6971,,,
Adrienne,Smith,,6795 Ransom Rd,Zeeland,MI,49464,03/31/06,A,
Anthony,Lewis,,10257 Summerwood Dr,Zeeland,MI,49464,07/30/07,S,Typo
AL,HOLTROP,,4850 Dellview Ct,Hudsonville,MI,49426-1664,,,
Alan,Russell,,3624 Diamond Dr,Hamilton,MI,49419-9707,,,
If anyone wants to see the result that I get goto: http://raoset.com/
tests/legion/index.php
Any help is greatly appreciated!
Thanks!