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
Hi,
If i want to use "load data infile" into selected column, for example i have
5 column in one table and i only load data into column 1,2,4 and 5 and i use "load
data infile "abc.txt" replace into table test(t1,t2,t4,t5)" but after i load into the
table, the previous data in colum
On Tue, 24 Jun 2003 00:02:43 -0400, mysql wrote:
> I use version 4.0.12-max-debug.
>
> mysql> returns the following error code when I use the load data command.
>
> mysql> load data local infile "foo.txt" into table pet;
> ERROR 1148: The used command is n
mySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, June 24, 2003 2:02 PM
Subject: Q: LOAD DATA command error
I use version 4.0.12-max-debug.
mysql> returns the following error code when I use the load data command.
mysql> load data local infile "foo.txt" into table pet;
ERRO
"load data" options.
- Original Message -
From: mysql
To: mySQL List
Sent: Tuesday, June 24, 2003 12:02 AM
Subject: Q: LOAD DATA command error
I use version 4.0.12-max-debug.
mysql> returns the following error code when I use the load data command.
mysql> load data local in
I use version 4.0.12-max-debug.
mysql> returns the following error code when I use the load data command.
mysql> load data local infile "foo.txt" into table pet;
ERROR 1148: The used command is not allowed with this MySQL version
Do I need to upgrade to a new version?
uford
- Original Message -
From: "Insanely Great" <[EMAIL PROTECTED]>
To: "Padma kuruganti" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 12:32 PM
Subject: Re: LOAD DATA command
> Greetings...
>
> Are you using Windows to con
ROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 12:46 AM
Subject: LOAD DATA command
> Hi I just downloaded version 3.23.53 for evaluation.
> when I try to use LOAD DATA LOCAL INFILE 'some.txt"
> into TABLE sometable I get a message saying 'the
i believe that this security issue came up with the .51 version of mysql
you can remove this block by adding this to your my.cnf file
[mysqld]
local-infile=1
[mysql]
local-infile=1
- hcir
On Friday, December 6, 2002, at 10:16 AM, Padma kuruganti wrote:
Hi I just downloaded version 3.23.53 fo
Hi I just downloaded version 3.23.53 for evaluation.
when I try to use LOAD DATA LOCAL INFILE 'some.txt"
into TABLE sometable I get a message saying 'the used
command is not allowed in this version of mySQL. IS
there any update on this? I could not find any info on
your web site.
Thanks
KP
__
Hi Joshua,
what exactly did you try? LOAD DATA INFILE seems to be working on my
box ;-)
Joshua Richards wrote:
>
> Hi,
> Could anyone please tell me how I could load a text file into a specific
> column in mysql.
> I tried LOAD DATA INFILE but didn't work
>
> Thanks,
>
> J.Richards
>
>
Hi,
Could anyone please tell me how I could load a text file into a specific
column in mysql.
I tried LOAD DATA INFILE but didn't work
Thanks,
J.Richards
-
Before posting, please check:
http://www.mysql.com/manual.php
Carl,
Monday, April 15, 2002, 11:34:09 PM, you wrote:
CM> We are attempting to put records into a table using the "load data" or
CM> mysqlimport commands. One quirk is with columns that include a timestamp
CM> type. When we import the records we get zeros in the timestamp column. How
CM> can w
On 15 Apr 2002, at 15:34, Carl McNamee wrote:
> We are attempting to put records into a table using the "load data" or
> mysqlimport commands. One quirk is with columns that include a timestamp
> type. When we import the records we get zeros in the timestamp column. How
> can we get the curren
We are attempting to put records into a table using the "load data" or
mysqlimport commands. One quirk is with columns that include a timestamp
type. When we import the records we get zeros in the timestamp column. How
can we get the current time inserted when using the "load data" or
mysqlimpo
If the table has a unique key then add the REPLACE keyword.
This will update the columns with new values if the key already exists
and add the row if it doesnt.
--Mark
Michael Kaiser wrote:
> Using the following inserts data from a text file into a particular MySQL
> table:
>
> LOAD DATA LOC
Using the following inserts data from a text file into a particular MySQL
table:
LOAD DATA LOCAL INFILE "file.txt" INTO TABLE whatever;
Is there any way to do this, but instead of inserting, it's updating?
Michael Kaiser
LivingLegend.net
[EMAIL PROTECTED]
"Many folk like to know beforehand wha
On Thu, Aug 23, 2001 at 08:35:44AM +0800, Osman Omar wrote:
> I have these data inside my tables
>
> id modelname datein
> 1 str-de345 20010901
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (th
I have these data inside my tables
id modelname datein
1 str-de345 20010901
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
nt: Monday, June 18, 2001 4:56 PM
To: '[EMAIL PROTECTED]'
Subject: I need to use the Load Data command to load the contents of a text
file into a table.
The problem is the text file resides on a server that holds the website
pages. I am new to UNIX. How do I setup the LOAD DATA INFI
The problem is the text file resides on a server that holds the website
pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to
specify the text file if it is loaded on another server?
This is what I have:
LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY '"'
TER
23 matches
Mail list logo