At 11:29 -0400 4/21/04, Chris Stevenson wrote:
I'm working through a self study book and I am trying to learn how to do
a "load data local infile". I downloaded a sample database and I have
the txt file but each time I type in the command LOAD DATA LOCAL INFILE
'member.txt' INTO TABLE member; I ge
Chris Stevenson wrote:
I'm working through a self study book and I am trying to learn how to do
a "load data local infile". I downloaded a sample database and I have
the txt file but each time I type in the command LOAD DATA LOCAL INFILE
'member.txt' INTO TABLE member; I get the following messa
I'm working through a self study book and I am trying to learn how to do
a "load data local infile". I downloaded a sample database and I have
the txt file but each time I type in the command LOAD DATA LOCAL INFILE
'member.txt' INTO TABLE member; I get the following message ERROR: File
'member.txt
Dion,
Let me repeat back to you the question that I heard you asking:
Can I load a text-file representation of a big, flat, single-table
unnormalized mess into a nicely normalized multi-table MySQL database all
in one fell swoop?
The answer I thought I heard from Bhavinder(?) Vyas was No, you
]>
To: "MySQL Help" <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 8:12 AM
Subject: newbie ? Load Data in MySQL
> I am working on a project were the customer info will be uploaded to a
MySQL
> database from multiple sources with a customer ID already assigned to them
> a
I am working on a project were the customer info will be uploaded to a MySQL
database from multiple sources with a customer ID already assigned to them
and this data needs to be related to other tables with related info. OK I
have an auto increment column set up as the primary key to keep track of
Hi
At 20:27 02/03/2002 +, [EMAIL PROTECTED] wrote:
>Hi,
>
>I am new to MySQL and to this list. I am currently going through Paul
>Dubois' book, "MySQL." I have set up MySQL on my Win 98 machine and am
>able to access and create databases and tables.
>
>The problem I am having is when I tr
Hi,
I am new to MySQL and to this list. I am currently going through Paul Dubois' book,
"MySQL." I have set up MySQL on my Win 98 machine and am able to access and create
databases and tables.
The problem I am having is when I try to LOAD DATA, I get the following error: "The
used command
