2013/12/18 11:07 -0500, Anthony Ball
I ran across a curious issue, I'd call it a bug but I'm sure others would
call it a feature.
I have a csv file with space between the and , and it causes MySQL to eat
that field and the field after it as a single field. Is there a setting I
can use to
(1)
yes it is an issue even i faced. for the remedy i search the {( ,) (,)}
values of , space between and , replaced by , in .csv itself.
(2)
The other way is, if all the values are like space between , then you can
use space and , in fields terminated by
LOAD DATA LOCAL INFILE
The answer is 3 =)
With myisam tables, you can have partially complete statements. That is if you
get an error, all rows handled before the error are still in the table. With
innodb, an error generates a rollback and your table is returned to its state
before the statement was run.
To find
At 05:40 AM 10/18/2009, John wrote:
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch which makes it much faster if you have
Group is a keyword in mysql:
You need to put backticks around it in your statement:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY '\n'
| (Page, Device, `GROUP` , ItemID, Item, Value);
On Mon, Jun 29, 2009 at 7:07 AM, Ralph
Johnny Withers schrieb:
Group is a keyword in mysql:
You need to put backticks around it in your statement:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY '\n'
| (Page, Device, `GROUP` , ItemID, Item, Value);
Ooookay.
LOAD DATA LOCAL INFILE
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
http://www.mysql.com/news-and-events/newsletter/2002-05/a12.html
-Original Message-
From: Velen [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 22, 2008 2:24 PM
To: mysql@lists.mysql.com
Subject: Load
Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 10/29/07, Dušan Pavlica [EMAIL PROTECTED] wrote:
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database.
Are you sure your file is coded in utf8? Character set of your file must
be same as charset of your database.
Dusan
Caleb Racey napsal(a):
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
Ananda Kumar wrote:
Hi,
Try this.
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
Rather:
set session collation_database=utf8_general_ci;
set session character_set_database=utf8;
Also, make sure you have these in my.cnf:
[client]
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql
Caleb Racey wrote:
On 10/26/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Caleb Racey wrote:
It is indeed buggy and badly documented. It depends on the current
database's character set instead. Try this:
SET NAMES utf8;
SET character_set_database=utf8;
LOAD DATA INFILE...
Baron
Thanks for
At 01:08 PM 6/27/2007, you wrote:
Hi,
I have a question on LOAD DATA INFILE command.
I have a table with 10 columns. Is it possible to update only few
columns of this table using LOAD DATA INFILE?
No. As you found out Load Data loads the specified columns and sets the
other columns to
Or,
Load the data into a temp , and create necessary index on the required
columns,
Write a stored proc to update columns in the original table with values from
the temp table based on key columns joins between both tables
regards
anandkl
On 6/28/07, mos [EMAIL PROTECTED] wrote:
At 01:08 PM
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv file so newlines are
Gerald L. Clark wrote:
Mark Nienberg wrote:
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a
mysql 5.0.22 table. Some of the fields contain text that has newline
characters in it. After reading the manual to learn how special
characters are treated, I altered the csv
Hi Julie,
If you notice after your import, you have 3 warnings. This intrigued
me, so I created a test case (also running 5.0.18 standard):
create table bit_test (b bit(8));
cat /tmp/bit_test.txt
01010101
2
b'010'
b\'010\'
0x2
02
mysql load data infile '/tmp/bit_test.txt'
'2' as binary data. And...it
worked!
Thanks so much for your input.
~ Julie
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
To: Julie Kelner [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, February 27, 2006 12:50 PM
Subject: Re: LOAD DATA INFILE and BIT columns
For any of you that run into this problem I found this:
After receiving some help from a friend it turns out that one of the
directories within the path to the target destination was not flagged 755,
and because of that one ( which happened to be 3 levels back) it didn't
allow mysql to properly
Do chmod -R 755 on datapath
Thanks
Praj
- Original Message -
From: Jay Paulson (CE CEN) [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, January 11, 2006 10:47 PM
Subject: LOAD DATA INFILE
I'm creating a file via PHP after getting information from a log file. I
create a
Hi Elliot,
It is in the docs, just a little bit further down the page 8-)
LOCAL works only if your server and your client both have been enabled
to allow it. For example, if mysqld was started with --local-infile=0,
then LOCAL does not work. See Section 5.6.4, Security Issues with LOAD
DATA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Arno Coetzee wrote:
Test USER wrote:
Can't get this to work, but i would like to specify LOAD DATA to use
an INFILE from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv' But i get
an error message saying file
I have never seen this. Mysql would have to do a wget of the file then dump it.
Last I knew it wasn't a web browser. There may be a way to do the wget inline
though, or at least write something in shell or perl to do it. Is this cron'd
or something, or a one time thing?
-
Hi thanks for your answer!
I would like this to be done via cron 3-4 times a day.
Quoting Peter J Milanese [EMAIL PROTECTED]:
I have never seen this. Mysql would have to do a wget of the file then
dump it. Last I knew it wasn't a web browser. There may be a way to do
the wget inline though,
Test USER wrote:
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
Gleb Paharenko wrote:
Hello.
Are you sure that you want to load PDF with LOAD DATA INFILE?
Well, I had been sure, but not so much anymore. s
Maybe LOAD_FILE is that you want:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Yup, this was the ticket. I'd seen several
Hello.
Are you sure that you want to load PDF with LOAD DATA INFILE?
Maybe LOAD_FILE is that you want:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Whil Hentzen wrote:
Hi folks,
I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the
following
At 23:46 +0100 11/2/05, John thegimper wrote:
Why cant i get this to work? The name dont get replaced... :P
LOAD DATA
LOCAL
INFILE '/tmp/myfile.txt'
INTO TABLE cache
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(name)
SET name = REPLACE(name, 'Coke', 'Pepsi');
Please file
Hello.
my mysql version is 4.2.2
Are you sure that you have this version? I strongly recommend you to
use the latest release (4.1.15 now).
The used command is not allowed with this MySQL version
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Yemi,
For a first debugging step, have php print out the $sql variable to a
screen. Then copy and paste that to a mysql client, and make sure you
get the same error. That's good to debug any script -- make sure the
query that the script is doing can actually run. Sometimes it's in
how php
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
Bob Cochran
Jason Ferguson wrote:
I am attempting to import a large file with data in this format:
1923158|GA|1996 Olympic Yachting
Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|-
81.08389Savannah
With this
Robert L Cochran wrote:
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
There's a lot to read there for one small paragraph, so from the above link:
Before MySQL 5.0.3, the column list must contain only names of columns
in the table being loaded, and the SET clause is not
I've been over that page before posting, with no luck. It might be an
obvious error in syntax, but I can't figure it out.
Jason
On 9/26/05, Robert L Cochran [EMAIL PROTECTED] wrote:
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
Bob Cochran
Jason Ferguson wrote:
I am
Okay, now I get it. I was using the 4.1 series. Looks like an upgrade is in
order.
Jason
On 9/26/05, Jasper Bryant-Greene [EMAIL PROTECTED] wrote:
Robert L Cochran wrote:
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
There's a lot to read there for one small paragraph, so from
Hi,
I have a file where the data looks like this:
1,23,345,45;
34,4,444,1er;
I am then trying to load that data using the load data local
infile and this statement:
Load data local infile '/httpd/htdocs/sql/loader.sql' into
table vehicles fields terminated by ',' enclosed by '
Hallo,
Op 30 Jun 05 schreef blackwater dev aan mysql@lists.mysql.com:
bd 1,23,345,45;
bd 34,4,444,1er;
bd Load data local infile '/httpd/htdocs/sql/loader.sql' into table
bd vehicles fields terminated by ',' enclosed by ' lines terminated by
bd ';'
I think it should be: enclosed by ''
Wrong path, you are referring to an uri, not a path. Way off topic to
starting explaining basic file system stuff here.
You should be the same path you used when your uploaded the
file. Something like:
/home/chris/datafile.txt
Frank
At 10:06 PM 6/7/05, Chris wrote:
Well, in
Chris wrote:
Thank you for your detailed response.
You're welcome.
It seems my problem is trying to define the path to my data file and this is
where I seem to be missing something.
No, the problem is permissions. As I explained previously, a relative
path (one without a leading /)
dont see any
difference between the two. if there is please elaborate.
- Original Message - .
From: [EMAIL PROTECTED]
To: °l||l° Jinxed °l||l° [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, June 07, 2005 3:17 AM
Subject: Re: LOAD DATA INFILE with INNODB
Hi,
you
work statement, start transaction and SET
AUTOCOMMIT=0;
regards
- Original Message -
From: [EMAIL PROTECTED]
To: °l||l° Jinxed °l||l° [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, June 07, 2005 11:08 AM
Subject: Re: LOAD DATA INFILE with INNODB
Hi,
i did it. If you have
At 03:59 PM 6/7/05, Chris wrote:
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt' not found
will be
appriciated thanks in advance
Haseeb Iqbal
- Original Message -
From: °l||l° Jinxed °l||l° [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, June 07, 2005 1:21 PM
Subject: Re: LOAD DATA INFILE with INNODB
hi,
yes you did it and i failed to do so
yes he is right i am doing the same. and giving full path. i have other
problems with load data infile :(
- Original Message -
From: Frank Bax [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, June 08, 2005 1:39 AM
Subject: Re: LOAD DATA INFILE - still confused
At 03:59 PM
PM
Subject: Re: LOAD DATA INFILE with INNODB
hi,
yes you did it and i failed to do so. thats why i am here.
i am using MYSQL 5.0.3 beta-standard with RedHat 9 , the test involves
only
innodb as i mentioned in the very first post,
i have read docs and it says that there are 3 ways i can
Well, in fact I have read the documentation several times before posting
this note.
My problem arises because I don't know what is meant by full file path. If
you mean: 'http://www.mydomain.com/datafile.txt' that produces the error:
Can't get stat of 'http:/www.mydomain.com/datafile.txt'
Hi,
you transaction is implicit, so there has been an autocommit.
Look at this example !
mysql start transaction;
^^
mysql load data infile 'd:\\ldfile.txt' into table ldfile;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
mysql
Subject: Re: LOAD DATA INFILE with INNODB
Hi,
you transaction is implicit, so there has been an autocommit.
Look at this example !
mysql start transaction;
^^
mysql load data infile 'd:\\ldfile.txt' into table ldfile;
Query OK, 3 rows affected (0.00 sec)
Records
Thank you for your detailed response.
It seems my problem is trying to define the path to my data file and this is
where I seem to be missing something. Permissions on all directories in the
path are by default set to 755 except for the director at the top of the
directories in my hosting account
Hi,
load data infile tries to load data from specified directory on the server.
if your file is on the client, try LOAD DATA LOCAL and verify the parameter
--enable-local-infile
more details are in http://dev.mysql.com/doc/mysql/en/load-data-local.html about
data on the web server.
Nota bene :
Chris wrote:
I have been using LOAD DATA INFILE to load an ASCII data file into my
database. The datafile is uploaded to the server temp area and the name of
the file is passed to LOAD DATA INFILE query like:
LOAD DATA INFILE '/tmp/phpyxCoes' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY
Hi,
If you let a tabulation, you will have 0 for numbers.
supposing this is the file tab.txt :
a 1 c
a c
mysql load data infile c:/tab.txt into table tab fields terminated by \t
enclosed by \ lines terminated by \r\n;
Query OK, 2 rows affected, 1 warning (0.00 sec)
Records:
thanks, that's what I feared already..
although ugly, will do it that way so far as I don't want to do any other
pre-processing on the fixed CSV's I receive.
moreover I just found out STR_TO_DATE isn't available in mysql 4.0 anyway..
Michael
-Original Message-
From: Jigal van Hemert
using mysql 4.0.24 I'm stuck with a problem importing a CSV-file
converting the date in the CSV from MM/DD/ to a mysql table..
I'm trying:
LOAD DATA INFILE '/tmp/mydata.csv'
INTO TABLE mytable
FIELDSTERMINATED BY ','OPTIONALLY ENCLOSED BY ''
(recordType,
@lists.mysql.com
Subject: Re: Load data infile and text fields
Date: Sun, 10 Apr 2005 02:32:28 +0200
Cc: [EMAIL PROTECTED]
Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]:
First of all I hope you can be patient for my english
I'm working with data import into mysql from a txt file
Am Samstag, 2. April 2005 13.51 schrieb [EMAIL PROTECTED]:
First of all I hope you can be patient for my english
I'm working with data import into mysql from a txt file. I'm using LOAD
DATA INFILE
command but I cannot correctly import a text column of 595 characters.
I receive this (very
@lists.mysql.com,
[EMAIL PROTECTED]
Subject: Re: Load data infile and text fields
Date: Mon, 4 Apr 2005 15:52:06 -0400
Stefano,
I'm copying this to the mailing list. I think it is a lot better if we
have
discussions of this kind on the mailing list so that others can also learn
from them, either
Hello.
Do you use a VARCHAR type for that column? It's maximum
length is limited to 255 characters. I think, switching to TEXT type
could solve the problem.
[EMAIL PROTECTED] wrote:
First of all I hope you can be patient for my english
I'm working with data import into mysql
documents. Each record should have a single word file.
I'd like to write a query (I hope without using api as php or other languages)
that imports automatically all .doc files stored ina dir. Have any idea?
Thanks
Stefano
-- Messaggio originale --
Subject: Re: Load data infile and text fields
From
[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 12:24 PM
Subject: Re: Load data infile and text fields
Rhino, many thanks for your answer! My problem is that I need a filed with
precision for a field of exactly 595 characters! Only text field type with
precision is the char type but its limit is 256
On Apr 4, 2005, at 3:52 PM, Rhino wrote:
Stefano,
I'm copying this to the mailing list. I think it is a lot better if we
have
discussions of this kind on the mailing list so that others can also
learn
from them, either now or in the future via the mailing list archive.
I'm glad to hear that you
What is the structure of the table you are importing to? you might have
merely hit the natural limit of the column type.
- michael dykman
On Sat, 2005-04-02 at 06:51, [EMAIL PROTECTED] wrote:
First of all I hope you can be patient for my english
I'm working with data import into mysql
Stefano,
The behaviour you are describing is normal, assuming that the column in your
MySQL table is defined as CHAR(255) or VARCHAR(255).
You didn't say which version of MySQL you are using. However, unless you are
using MySQL 5.0.3 or later, 255 is the largest size available for a CHAR or
At 05:18 PM 3/6/2005, Harrison Fisk wrote:
Hi,
On Mar 6, 2005, at 12:51 PM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process
on the MyISAM table.
I gave that a try but I had to cancel Alter Table ... Enable Keys after
49
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process
on the MyISAM table.
I gave that a try but I had to cancel Alter Table ... Enable Keys after
49 hours. I find it amazing that it takes only 6.25 hours to load 450
million rows into the
Hi,
On Mar 6, 2005, at 12:51 PM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading
process
on the MyISAM table.
I gave that a try but I had to cancel Alter Table ... Enable Keys
after 49 hours. I find it amazing that it takes only
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process
on the MyISAM table.
mos [EMAIL PROTECTED] wrote:
I have a 50g CSV file that I am trying to import into an empty MyISAM
table. It appears to go fine except after 10 hours it hasn't completed. A
Show
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process
on the MyISAM table.
That may work provided I can get the keys rebuilt later using FileSort and
not KeyCache.
You see the problem isn't in loading the data into the table which occurs
Hi,
On Mar 3, 2005, at 11:32 AM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading
process
on the MyISAM table.
That may work provided I can get the keys rebuilt later using FileSort
and not KeyCache.
You see the problem isn't in
At 12:39 PM 3/3/2005, Harrison Fisk wrote:
Hi,
On Mar 3, 2005, at 11:32 AM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process
on the MyISAM table.
That may work provided I can get the keys rebuilt later using FileSort
and
Hi,
On Mar 3, 2005, at 3:13 PM, mos wrote:
At 12:39 PM 3/3/2005, Harrison Fisk wrote:
Hi,
On Mar 3, 2005, at 11:32 AM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading
process
on the MyISAM table.
That may work provided I can get
Hello.
Use 'SELECT INTO OUTFILE ...'
See:
http://dev.mysql.com/doc/mysql/en/select.html
shaun thornburgh [EMAIL PROTECTED] wrote:
Hi,
The following function loads data from a file:
http://dev.mysql.com/doc/mysql/en/load-data.html
Is there a function like this that I
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Hi,
The following function loads data from a file:
http://dev.mysql.com/doc/mysql/en/load-data.html
Is there a function like this that I can use to save the
results of a query to a CSV file for the user of my PHP
application to
shaun thornburgh [EMAIL PROTECTED] wrote on 02/15/2005
04:53:54 PM:
Hi,
I have a table with 26 fields, each row in this table must be unique. I
can't define all of the fields to be primary keys as the limit is 16.
Therefore before I insert data I have to check that each row is unique.
Hi,
Thanks for your reply, but the problem I am facing is that there may be
duplicate values in the uploaded file and I dont want these to appear in my
table...
From: Bastian Balthazar Bux [EMAIL PROTECTED]
To: shaun thornburgh [EMAIL PROTECTED]
Subject: Re: LOAD DATA INFILE using 4.0.17
Date
: LOAD DATA INFILE using 4.0.17
Hi,
Thanks for your reply, but the problem I am facing is that there may be
duplicate values in the uploaded file and I dont want these to appear in
my
table...
From: Bastian Balthazar Bux [EMAIL PROTECTED]
To: shaun thornburgh [EMAIL PROTECTED]
Subject: Re
: Bastian Balthazar Bux [EMAIL PROTECTED]
To: shaun thornburgh [EMAIL PROTECTED]
Subject: Re: LOAD DATA INFILE using 4.0.17
Date: Tue, 15 Feb 2005 23:32:56 +0100
shaun thornburgh ha scritto:
Hi,
I have a table with 26 fields, each row in this table must be
unique. I can't define all
No just every row needs to be unique. Sorry for the confusion...
From: Robert Dunlop [EMAIL PROTECTED]
To: shaun thornburgh
[EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: LOAD DATA INFILE using 4.0.17
Date: Tue, 15 Feb 2005 15:06:19 -0800
So what you meant was every field in each row must
Richard Whitney mailto:[EMAIL PROTECTED] wrote on Tuesday, January 04, 2005
6:16
PM:
I think I'm bringing this up again but with different errors.
This: $sql = LOAD DATA INFILE '$file'
REPLACE INTO TABLE `jobs` FIELDS
TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED
Hello.
Similar problems are described at:
http://dev.mysql.com/doc/mysql/en/Connection_access.html
Richard Whitney [EMAIL PROTECTED] wrote:
I think I'm bringing this up again but with different errors.
This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE
Goutham
Thanks for your help. The problem in this case was line endings. I use an
Apple g4 for web work on system 10.2. By default BBEdit uses macintosh line
endings. MySQL does not recognize them. As soon as I changed the textfile
format to unix line endings, it imported the data without any
Hi Rob,
LOAD DATA INFILE is not a very verbose command. It
doesn't spill out the exact root cause of the error.
Forgive me, if I seem to be wrong for anybody who had
a different opinion.
mysqlimport is a wrapper around LOAD DATA INFILE with
a lot of command line options. You might try your luck
Software Engineer,
Hewlett Packard
--- rob byrne [EMAIL PROTECTED] wrote:
I am trying to load data from a text file into a
table using the Load data
infile statement. No matter how I change data types
I seem only able to load
in the first row of data into the MySQL table and no
more. I have not
Hello.
Looks like LOAD DATA INFILE supports only string constants in
its syntax. I think it has sense, because security risk grows,
when we can substitute variables in the file name.
Scott Klarenbach [EMAIL PROTECTED] wrote:
I can't seem to make the Load Data statement work inside of
Somewhere about Sat, 20-Nov-2004 at 06:27PM +0100 (give or take), Ferhat BINGOL
wrote:
| Hi,
|
| I have a 72 fields data txt file and I was inserting all data
| previously but now I need only some of them to dump into the table.
| I would like to select only 4 fields which are the 1st,
.
thanks to MySQL.
:)
thank yo again for answer...
- Original Message -
From: Patrick Connolly [EMAIL PROTECTED]
To: Ferhat BINGOL [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Sunday, November 21, 2004 10:00 AM
Subject: Re: LOAD DATA INFILE question...
Somewhere about Sat, 20
You can load the file to an intermediate table and then complete your
process using
INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM intermediateTABLE
Ferhat BINGOL wrote:
Hi,
I have a 72 fields data txt file and I was inserting all data previously
but now I need only some of
BINGOL [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Saturday, November 20, 2004 10:41 PM
Subject: Re: LOAD DATA INFILE question...
You can load the file to an intermediate table and then complete your
process using
INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM
Hi.
If your table has a unique index on field 'name',
then use
load data infile 'file' replace into table 'table';
Lewick, Taylor [EMAIL PROTECTED] wrote:
Can I perform an update on a table using load data infile..?
If I have the following table...
Name Score Rank
mysql load data infile 'abcd.txt' into table b.chicago;
' for key 1 Duplicate entry '[EMAIL PROTECTED]
I think you have 2 e-mails that are equal in the file and the e-mail field is
declared as a primary key (which implies UNIQUE).
--
mack /
--
MySQL General Mailing List
For list archives:
What is the current value for you id field? Approximately how many records
are you inserting?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/20/04 3:16 AM
Subject: load data infile
Dear freinds,
I am still getting errors.Load infile script. Guidance , please.
Dear friend,
I tried the IGNORE option so that data is loaded from the file to table,
still getting error pasted below. Any advice.
mysql use b
Database changed
mysql describe chicago
- ;
For this type of custom loading you may want to explore a programming
language such as Java or C/C++ or Perl. Depending on your platform you could
even explore some third party tools.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/4/04 3:27 PM
Subject: load data
sean c peters wrote:
But when I load a parent table, an auto_increment column
autogenerates a value that will be a foreign key in a child table. So i cant
create the file to load into the child table until after the parent table has
been loaded. Then i'll need to get back all the auto increment
Somewhere about Sun, 01-Aug-2004 at 11:31AM -0400 (give or take), Michael Stassen
wrote:
|
| Patrick Connolly wrote:
[...]
| Looks to me the mysql user should have no trouble with it:
|
| -rw-rw-r--1 pat pat 332 Jun 28 20:42 Orders.txt
|
| Every piece of the path to
Somewhere about Sat, 31-Jul-2004 at 11:17AM -0400 (give or take), Michael Stassen
wrote:
| With LOCAL, the *client* reads the file on the client's machine.
| Without LOCAL, the *server* reeads the file on the server's
| machine. Even though the client and server machines are the same
| in your
Patrick Connolly wrote:
Somewhere about Sat, 31-Jul-2004 at 11:17AM -0400 (give or take), Michael Stassen
wrote:
| With LOCAL, the *client* reads the file on the client's machine.
| Without LOCAL, the *server* reeads the file on the server's
| machine. Even though the client and server machines
With LOCAL, the *client* reads the file on the client's machine. Without
LOCAL, the *server* reeads the file on the server's machine. Even though
the client and server machines are the same in your case, those are still
different operations. There are restrictions on having the server do the
Resolved, used this syntax...
LOAD DATA INFILE '/path/from/root/to/file.csv' INTO TABLE ma0133 FIELDS
TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' LINES
TERMINATED BY '\r\n'
- Phil.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
1 - 100 of 220 matches
Mail list logo