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
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
No, there is no way to trigger an insert automatically when you are doing a
LOAD DATA (bulk load). You will need another flat file with the appropriate
info and load that in as well...just as you have thought of.
- Original Message -
From: "Dion Wickander" <[EMAIL PROTECTED]>
To: "MySQL He
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
