@lists.mysql.com
Subject: Re: Problem with load data and NULL
In article [EMAIL PROTECTED],
Barbara Deaton [EMAIL PROTECTED] writes:
All,
I need help with using load data to load a text file that is created by
another application.
I have a text file that contains 2 columns, date and smallint and 2 rows
In article [EMAIL PROTECTED],
Barbara Deaton [EMAIL PROTECTED] writes:
Thank you for the idea. It fixed my date problem, but my numeric column is
still 0 and NOT NULL. Here's what I did:
create table a (
d date default null,
e smallint default null );
CREATE TEMPORARY TABLE
In article [EMAIL PROTECTED],
Barbara Deaton [EMAIL PROTECTED] writes:
All,
I need help with using load data to load a text file that is created by
another application.
I have a text file that contains 2 columns, date and smallint and 2 rows:
d,e
2005-12-31,
,2
In the above example
All,
I need help with using load data to load a text file that is created by another
application.
I have a text file that contains 2 columns, date and smallint and 2 rows:
d,e
2005-12-31,
,2
In the above example the first row, column e should be NULL and the second row
column d should be
Hello,
I am using mysql Ver 14.6 Distrib 4.1.5-gamma, for sun-solaris2.8 (sparc)
I am having a problem with using the following query from a perl program:
LOAD DATA LOCAL INFILE ? REPLACE INTO TABLE $table
The error I get is:
DBD::mysql::st execute failed: The used command is not allowed with
Hi,
I am facing problem while inserting more than 20,000 records using LOAD
DATA INFILE statement through comma seperated file.
Here is my statement:
LOAD DATA LOCAL INFILE '/home/mysql/isa_logs/a.txt' INTO TABLE
FirewallLog_1 FIELDS TERMINATED BY ',';
I have persistantly observed that when
Alpesh Kothari wrote:
Hi,
I am facing problem while inserting more than 20,000 records using LOAD
DATA INFILE statement through comma seperated file.
Here is my statement:
LOAD DATA LOCAL INFILE '/home/mysql/isa_logs/a.txt' INTO TABLE
FirewallLog_1 FIELDS TERMINATED BY ',';
I have persistantly
OS Linux Red Hat 7.2
MySql 3.23.41
Hi All!
That is my steps.
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
With client privileges !!!
I doing:
mysql -u client -p
passwd
CREATE DATABASE mydb;
I got:
OK
CREATE TABLE mytable ( col01
On Sat, 15 Jun 2002, Sergey Bondar wrote:
OS Linux Red Hat 7.2
MySql 3.23.41
Hi All!
That is my steps.
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
The user needs the file privilege.
Granting all on mydb.* does not give this
OS Linux Red Hat 7.2
MySql 3.23.41
Hi All!
That is my steps.
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
With client privileges !!!
I doing:
mysql -u client -p
passwd
CREATE DATABASE mydb;
I got:
OK
CREATE TABLE mytable ( col01
On Fri, 14 Jun 2002, Sergey wrote:
snip
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
snip
Then I doing:
LOAD DATA INFILE /usr/data/myfile INTO TABLE tab01;
I got:
ERROR 1045 Access denied fot user: 'client@localhost' (Using
At 20:23 -0400 6/14/02, Sergey wrote:
OS Linux Red Hat 7.2
MySql 3.23.41
Hi All!
That is my steps.
With root privileges
I doing:
GRANT ALL ON mydb.* TO client@localhost identified by pwd;
I got:
OK
With client privileges !!!
I doing:
mysql -u client -p
passwd
CREATE DATABASE mydb;
I got:
Dear all
I had a query here, could someone pls tell me what is in there?
load data infile 'c:/rate/hkd_rate.csv' into table hkd_deposit
(hkd_chiperiod) fields terminated by ','
This error comes out:
you have an error in your SQL syntax near 'fields terminated by ', at line
1
Aim:
What i wan to
]
- Original Message -
From: Jack [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 9:58 AM
Subject: Problem on Load Data!
Dear all
I had a query here, could someone pls tell me what is in there?
load data infile 'c:/rate/hkd_rate.csv' into table hkd_deposit
Message-
From: ali hafiz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 2:23 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: problem on Load Data!
Hi Jack,
For question1, I think you need to use insert with set:
insert into table ABC
set column3 =
PROTECTED], [EMAIL PROTECTED]
Subject: problem on Load Data!
Date: Mon, 6 May 2002 12:40:08 +0800
Dear all
Two Question :
1.
I know that the 'LOAD DATA' command loads a bulk of data into a table, but
what happen if i only want to load the data into specifc fields on a table
instead of whole table
]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: problem on Load Data!
Hi Jack,
For question1, I think you need to use insert with set:
insert into table ABC
set column3 = ,
column4 = ,
column5 = ;
I think that should do it.
Have you managed to find an answer to question2
];
[EMAIL PROTECTED]
Subject: RE: problem on Load Data!
I think you have to use a forward slash in your path instead of a
backslash.
C:/ as opposed to C:\
even in windows operating environments I believe you need to use /.
-Original Message-
From: ali hafiz [mailto:[EMAIL PROTECTED]]
Sent
PROTECTED]
Subject: RE: problem on Load Data!
Wrong. Windows uses \ for their paths, so MySQL should use the same
thing.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Bob Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:59 PM
To: 'ali hafiz
Jack,
Monday, May 06, 2002, 7:40:08 AM, you wrote:
J Two Question :
J 1.
J I know that the 'LOAD DATA' command loads a bulk of data into a table, but
J what happen if i only want to load the data into specifc fields on a table
J instead of whole table.
J eg.
J Let say i had a file with 3 column
Dear all
Two Question :
1.
I know that the 'LOAD DATA' command loads a bulk of data into a table, but
what happen if i only want to load the data into specifc fields on a table
instead of whole table.
eg.
Let say i had a file with 3 column of data, and i want to load these data
into a 'ABC'
At 23:34 -0500 4/20/02, Darren Vollmer wrote:
Both files are world readable.
How do you know this?
Because FTP tells me they are.
Also, when you say client machine, what do you mean? In particular,
are the web server and the MySQL servers running on the same machine?
Client
Darren,
Friday, April 19, 2002, 3:33:50 PM, you wrote:
DV I am having problems with load data local infile.
DV The mysql host server is running 3.23.23
DV I was able to successfully use load data local infile before to import data
DV off of a client machine onto the mysql host but now all i
The file does exist. The file and its directory are 0777 permission.
Darren
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 4:32 AM
Subject: Re: problem with load data local infile
Darren,
Friday, April 19, 2002
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should have permissions to go through dirs ...
DV Darren
--
For
Darren,
Saturday, April 20, 2002, 2:34:06 PM, you wrote:
DV The file is in a world readable directory tree.
DV Shouldn't the LOCAL qualifier make mysql read the file from the client
DV running and not the host?
DV I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
DV
Subject: Re: Re: problem with load data local infile
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 6:28 PM
Subject: Re: Re: problem with load data local infile
The error I receive is:
Can't stat file 'filename' (errcode 2)
I noticed what you mentioned about
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:28 PM
Subject: Re: Re: problem with load data local infile
The error I receive is:
Can't stat file 'filename' (errcode 2)
It can't stat *filename*? Don't
error message
then
can't get stat of 'filename' (Errcode 2)?
Thanks for your help and patience
Darren
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:36 PM
Subject: Fw: Re: problem with load data local infile
- Original
Both files are world readable.
How do you know this?
Because FTP tells me they are.
Also, when you say client machine, what do you mean? In particular,
are the web server and the MySQL servers running on the same machine?
Client machine is the machine running the webserver and MySQL
I am having problems with load data local infile.
The mysql host server is running 3.23.23
I was able to successfully use load data local infile before to import data
off of a client machine onto the mysql host but now all i get is a
can't stat file errcode2 message.
I know that the pathname I
I never saw this message make this list so I'm reposting it.
- Original Message -
From: Darren Vollmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 7:33 AM
Subject: problem with load data local infile
I am having problems with load data local infile
Dear all, I had a problem with load data infile syntax
LOAD DATA INFILE '$file' REPLACE INTO TABLE $table FIELDS TERMINATED BY '|'
that the original data has already carriage returns was considered as new
records in the database, I solved it by using the following syntax:
LOAD DATA INFILE '$file
HI ALL: Happy New Year ;)
I have a text file generated from MSAccess database, one of the
fields (Long Text) have Carriage returns within the text, So
the data of some records falls in more than one line in the
text file, when I'm using the SQL statement LOAD DATA INFILE...
I have only the
Are you using mysqlimport utility? If not that may be you answer?
If so what flags are you setting?
david
HI ALL: Happy New Year ;)
I have a text file generated from MSAccess database, one of the
fields (Long Text) have Carriage returns within the text, So
the data of some records
PROTECTED]
Subject: Problem with LOAD DATA INFILE
Hello all,
I have a problem. I am able to get a copy of a text file which resides
on another server for a task I am completing. What I need to do is
import this text into a database table on a nightly basis, and I am
trying to set this up via PHP so
Hello all,
I have a problem. I am able to get a copy of a text file which resides
on another server for a task I am completing. What I need to do is
import this text into a database table on a nightly basis, and I am
trying to set this up via PHP so it is all automated. I have one
problem
38 matches
Mail list logo