>> 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
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 t
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 wha
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
---
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
-