>> 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
ello Paul,
can you try this and let see if it is going to work !
UNLOAD DATA FROM TABLE fred INTO LOCAL OUTFILE "file.txt";
And if it fails, i am sure somebody their will correct it!
Regards.
kamal
>Hi,
>
>Is there a reason why, if I can
>
>LOAD DATA LOCAL INFILE 'file' INTO TABLE fred;
>
>w
Hi,
I just discovered that I have to move the data text file I want to store in
my table into bin directory of mysql directory (c:\mysql\bin\) before
the LOAD DATA local infile "text.txt" INTO TABLE tabname can work.
The problem here is that how do I then transfer this kind of file from my
l
Compliments,
I was able to uccessful install MySQLGUI version 1.75 on my win 98 running
MySQL server 3.23.43 -max-debug client version 3.23.3 alpha.
I was also able to connect to the server. At the bottom of the window I saw
one button with plus sign, when I do mouse over on it there is this pop
>I suspect that you need to add an entry at the MySQL host for the machine
that you are connecting from. This can be done with a GRANT statement:
>
>- Format:
>grant all privileges on databaseName.tableName
>to 'userName'@'hostName'
>identified by 'somePassword';
>
>
>- Example
At 03:23 PM 12/10/01 -0700, you wrote:
>From: Dan <[EMAIL PROTECTED]>
>
>> I can connect... on the same computer
>> ...different machine it won't work.
I have a similar problem but let explain better may be i don't get what Dan
was talking about. From my local computer i can use LOAD command to s
Dear All,
I have Mysql server installed at remote site which i need to connect to.
I have tried this from my local computer but didn't work;
c:\mysql\bin>mysql -h myhost -u myusername -pmypassword
I will also like to use LOAD command to load a text file from my local
computer to the database o
