Hi,
I am having problems loading data into a table and have 2 questions.
1)
I want to load some data from a text file in to a table by using the
following line:
LOAD DATA LOCAL INTO st.txt INTO TABLE studio;
With this you have to save your text file inside the bin folder of your
mysql
Hi,
When using the command:
LOAD DATA LOCAL INFILE xxx.txt INTO TABLE [TABLE NAME];
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Hi,
When using the command:
LOAD DATA LOCAL INFILE xxx.txt INTO TABLE [TABLE NAME];
where should the txt file be located?
Thanks
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
Inderpal Singh writes:
When using the command:
LOAD DATA LOCAL INFILE xxx.txt INTO TABLE [TABLE NAME];
where should the txt file be located?
That's up to you to decide, but as _always_ when you do something
to a file, you must give some sort of valid path (absolute
or relative or
LOAD DATA LOCAL INFILE location of text file INTO TABLE [tablename]
- Original Message -
From: Inderpal Singh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 16, 2001 8:12 AM
Subject: Location of text file for loading data in to table
Hi,
When using the command:
LOAD