RE: Re: Problem with load data and NULL

2005-11-08 Thread Barbara Deaton
@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

Re: Problem with load data and NULL

2005-11-08 Thread Harald Fuchs
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

Re: Problem with load data and NULL

2005-11-05 Thread Harald Fuchs
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

Re: Problem in LOAD DATA INFILE

2005-01-12 Thread gerald_clark
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

Re: Problem with load data infile and user's privileges

2002-06-15 Thread Jason Englehardt
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

Re: Problem with load data infile and user's privileges

2002-06-14 Thread Galen Wright-Watson
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

Re: Problem with load data infile and user's privileges

2002-06-14 Thread Paul DuBois
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:

Re: Problem on Load Data!

2002-05-17 Thread Gelu Gogancea
load data infile 'c:/rate/hkd_rate.csv' into table hkd_deposit (hkd_chiperiod) fields terminated by '\,'; _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -

RE: problem on Load Data!

2002-05-10 Thread Paul DuBois
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 =

Re: problem on Load Data!

2002-05-09 Thread ali hafiz
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? Please let me know. Ali From: Jack [EMAIL PROTECTED] To: [EMAIL

RE: problem on Load Data!

2002-05-09 Thread Bob Ryan
]; [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

RE: problem on Load Data!

2002-05-09 Thread Matthew Walker
]; [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

RE: problem on Load Data!

2002-05-09 Thread Bob Ryan
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

Re: problem on Load Data!

2002-05-06 Thread Victoria Reznichenko
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

Re: Re: problem with load data local infile

2002-04-21 Thread Paul DuBois
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

Re: problem with load data local infile

2002-04-20 Thread Victoria Reznichenko
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

Re: problem with load data local infile

2002-04-20 Thread Darren Vollmer
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

Re: Re: problem with load data local infile

2002-04-20 Thread Victoria Reznichenko
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

Re: Re: Re: problem with load data local infile

2002-04-20 Thread Victoria Reznichenko
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

Re: Re: problem with load data local infile

2002-04-20 Thread Paul DuBois
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

Fw: Re: problem with load data local infile

2002-04-20 Thread Fiasco
- 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

Fw: Re: problem with load data local infile

2002-04-20 Thread Fiasco
- 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

Re: Re: problem with load data local infile

2002-04-20 Thread Fiasco
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

Re: Re: problem with load data local infile

2002-04-20 Thread Darren Vollmer
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

Re: Problem with LOAD DATA INFILE

2001-12-31 Thread David J Jackson
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

RE: Problem with LOAD DATA INFILE

2001-10-31 Thread Rick Emery
I suggest writing a PERL script/filter which accepts the text file and sends a comma-delimited file to standard-out. This file could then be sucked in by mysql -Original Message- From: Michael Benbow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 7:48 PM To: [EMAIL