Daniel,
Monday, April 22, 2002, 2:31:15 PM, you wrote:
DJ> I'm having difficulties with loading values from a text file into my
DJ> databse.
DJ> I've tried the following and got these errors. last one is with full path
DJ> ===
DJ> mysql> LOAD DATA INFILE "months.txt" INTO TABL
Disregard my last post..
- Original Message -
From: "Daniel Jarrett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 11:44 PM
Subject: Re: load data infile problems
> i figured it out.. it worked when i used local.
>
> although
nual a bit cryptic
dan
- Original Message -
From: "Melvyn Sopacua" <[EMAIL PROTECTED]>
To: "Daniel Jarrett" <[EMAIL PROTECTED]>
Cc: "MySQL General" <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 9:48 PM
Subject: Re: load data infile problems
Chris Book writes:
> My actual data has " represented as "", so I need to set it up this way. I
> would prefer to work with the files the way they are now rather than
> re-export my data a different way, since that machine is inconvenient right
> now.
>
> I can export data using the same param
Chris Book writes:
> load data local infile 'file.txt' into table mytable fields optionally
> enclosed by '"' escaped by '"' terminated by ','
I'm not sure how mysql handles the case where the escape
character is the same as the field enclosing character, and
I can see a problem here if you hav
i had similar problem until used line delimiter different than default "\n"
try this:
load data local infile 'file.txt' into table mytable fields optionally
enclosed by '"' escaped by '"' terminated by ',' LINES TERMINATED BY '-= aNy
we1Rd cHar 0r Str1Ng =-'
:)
-Original Message--
