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
I'm having difficulties with loading values from a text file into my
databse.
I've tried the following and got these errors. last one is with full path
===
mysql> LOAD DATA INFILE "months.txt" INTO TABLE months;
ERROR 1105: File './date1/months.txt' not found (Errcode: 2)
mysq
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
7;-= aNy
we1Rd cHar 0r Str1Ng =-'
:)
-Original Message-
From: Chris Book [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:53 PM
To: [EMAIL PROTECTED]
Subject: load data infile problems
Hello,
This is what I'm trying to do:
load data local infile 'file.txt
Hello,
This is what I'm trying to do:
load data local infile 'file.txt' into table mytable fields optionally
enclosed by '"' escaped by '"' terminated by ','
My file looks like this
1,"data1"
2,"data2"
3,"data3"
etc
my table is defined with (id integer not null, data varchar(200) not null).
Th