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 TEMPO
Fuchs
Sent: Saturday, November 05, 2005 10:03 AM
To: mysql@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 crea
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 abo
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 NULL
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 t
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 giv
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 CHAR(
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 DATAB
On Fri, 14 Jun 2002, Sergey wrote:
> With root privileges
> I doing:
> GRANT ALL ON mydb.* TO client@localhost identified by "pwd";
> I got:
> OK
>
>
> Then I doing:
> LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01;
> I got:
> ERROR 1045 Access denied fot user: 'client@localhost' (Using
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 CHAR(
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
> >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
get a different 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
- 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&
- 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 'filena
Message -
>From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, April 20, 2002 6:14 AM
>Subject: Re: Re: problem with load data local infile
>
>
>> Darren,
>> Saturday, April 20, 2002, 1:23:54 PM, you wrote:
>
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
server?
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 20, 2002 6:14 AM
Subject: Re: Re: problem with load data local infile
> Darren,
> Saturday, April 20, 2002, 1:23:54 PM, you wrote:
>
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
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, 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
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 proble
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
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:
LOA
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 f
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 fir
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 it
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 tho
28 matches
Mail list logo
