Hi all,
I've a question, i need to killing a "load data in file". Normally used
"show processlist" and "kill PID". But don't work.
any idea?
Thanks :D
{ name : "Rafael Valenzuela",
open source: ["Saiku Admin Console","Anaytical Sport"],
location : "Madrid Spain",
twitter : ["@
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
(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 '/tmp
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 remedy this or do I just have to make sure n
Hello,
after switching from MySQL 5.0.67 to 5.1.59 we get the following problem:
We want to import data from a textfile
example of the textfile:
t...@test.com$yes$432145$xyz
The command is: LOAD DATA LOCAL INFILE 'textfile.txt' INTO TABLE TESTTABLE
FIELDS TERMINATED BY '$';
Selecting the data
mysql 5.1.53 after i see
some post on the internet saying we have some issues in the older version ,
but it keeps giving the same error.
thanks
Anand
On Mon, Dec 20, 2010 at 7:42 PM, who.cat wrote:
> i wanna know you have done LOAD DATA INFILE in master ,why are you tring
> to do it
On Mon, Dec 20, 2010 at 9:00 AM, Anand wrote:
> Hi guys,
>
> i am facing a serious issue with my replication , i tried so many things
> but no luck.
>
> my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
>
> we run LOAD DATA INFILE in master to pr
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand :
> Hi guys,
>
> i am facing a serious issue with my replication , i tried so many things but
> no luck.
>
> my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
Hi guys,
i am facing a serious issue with my replication , i tried so many things but
no luck.
my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
we run LOAD DATA INFILE in master to process some csv files and load it into
a table, it runs perfectly well in master but
: Monday, October 25, 2010 12:16 PM
To: mysql@lists.mysql.com
Subject: Load Data Infile Errors
Hello,
I have a question about the execution cycle of LOAD DATA INFILE.
If I issue a large file via LDI LOCAL, I know that the file is copied to
the MySQL server and executed there.
But at what point
Hello,
I have a question about the execution cycle of LOAD DATA INFILE.
If I issue a large file via LDI LOCAL, I know that the file is copied to
the MySQL server and executed there.
But at what point does the statement finish from the sender's point of view?
1) When the file is success
e data, load the data, then do an Alter Table .. add index
> > for all of the indexes?
> > Or is it faster to just leave the indexes in place prior to loading the
> > data.
> >
> > I know if the table is empty and optimized, the non-unique indexes will
> be
gt; loading the data, load the data, then do an Alter Table .. add index
> for all of the indexes?
> Or is it faster to just leave the indexes in place prior to loading the
> data.
>
> I know if the table is empty and optimized, the non-unique indexes will be
> built AFTER t
dexes will
be built AFTER the data is loaded using Load Data Infile, but the unique
and primary indexes will be built as the data is being loaded and this
is going to slow down the import.
There is no point doing a Disable Indexes on the table because this only
affects non-unique indexes and th
for all of the indexes?
Or is it faster to just leave the indexes in place prior to loading the data.
I know if the table is empty and optimized, the non-unique indexes will be
built AFTER the data is loaded using Load Data Infile, but the unique and
primary indexes will be built as the
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
I'm trying to speed up Load Data Infile and after some experimenting have
noticed this "qwirk".
BTW, all of the tables used below are empty and have identical table
structures. The value being loaded into the primary key column is 'NULL'.
Test1:
246 seconds to ru
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 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);
like to import the first file field to the second table
field, the second file field to the third table,... Just to have an index.
I'm using:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY
You should increase parameter named max_bulk_insert_buffer_size and
max_allowed_packet.
On 8/21/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Mysql use tmpdir,
> when ever there is any index creation.
>
> regards
> anandkl
>
>
> On 8/21/08, jthorpe <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> >
Mysql use tmpdir,
when ever there is any index creation.
regards
anandkl
On 8/21/08, jthorpe <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I've been trying to import a 10G dump file using mysqlimport
> and it is eventually failing because it runs out of tmpdir
> space -- I get Errcode: 28.
>
> I was su
Hi,
I've been trying to import a 10G dump file using mysqlimport
and it is eventually failing because it runs out of tmpdir
space -- I get Errcode: 28.
I was surprised that it was using a temp file at all. I've
looked in the documentation and other sources but have not been
able to find anything
data infile
Hi,
I would like to know if I can use the Load data infile to update a table on the
server from a workstation?
I tried it but was unsuccessful. Is there any other way to do this from a
workstation?
Thanks.
Regards,
Velen
--
MySQL General Mailing List
For list archives: http
Hi,
I would like to know if I can use the Load data infile to update a table on the
server from a workstation?
I tried it but was unsuccessful. Is there any other way to do this from a
workstation?
Thanks.
Regards,
Velen
i read about mysqlimport & load data infile for mysql, but i can't find a
way to import text file using length of column, instead of delimiter
my text file contains fixed length column:
<><--><---><-><>
i can use ms excel to conv
hi all,
right now i'm trying to migrate from db2 running under linux to mysql v5.1.
i manage to export out the db2 structure & data into a del (ascii) file.
but when i try to load the data from the del file to mysql table, it
generate an error.
below is the load data infile syn
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]
default-charact
f 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
> > mysqld server is started wit
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
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...
Bar
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
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 below
LOAD DATA
Hi Friend,
Today I was testing the command 'Load data infile ...' command (
http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html ) in my system.
That time I was surprised when I put select statement in that table. The
scenario as follows :
In a text file which is to be loaded, I
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
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
wrote:
Hi All,
I am loading data into mysql database using LOAD DATA INFILE. After the
load i am getting this error.
Warning | 1366 | Incorrect string value: '\xE9cor' for column
'CATEGORY_NAME' at row 2137 .
My database character set is as below
character_set_database |
Also friends,
When i see this data in the vi editor it looks like this " Other Home DÃ(c)cor
"
Just wanted to give information. Please help me.
regards
anandkl
On 5/19/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All,
I am loading data into mysql database using LOAD DATA I
Hi All,
I am loading data into mysql database using LOAD DATA INFILE. After the load
i am getting this error.
Warning | 1366 | Incorrect string value: '\xE9cor' for column
'CATEGORY_NAME' at row 2137 .
My database character set is as below
character_set_database | utf8
During Replication the SLAVE reads data from its MASTER's log. Chances
are LOAD DATA gets no logging -- I won't be surprised.
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 9:44 AM
To: MySQL List
Subject: Replication & LOAD DAT
I've just performed a LOAD DATA INFILE on the master server, and I've waited
a while now, and the data has not shown up in the SLAVE. Does Replication
not handle LOAD DATA INFILE?
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
At 21:39 -0400 10/14/06, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date field
6 / FAX: 860.674.8341
> -Original Message-
> From: Ferindo Middleton [mailto:[EMAIL PROTECTED] ]
> Sent: Saturday, October 14, 2006 9:40 PM
> To: mysql
> Subject: change format of date fields during LOAD DATA INFILE?
>
> Is there a way to change the format of date field
6 9:40 PM
> To: mysql
> Subject: change format of date fields during LOAD DATA INFILE?
>
> Is there a way to change the format of date fields MySQL is
> expecting when
> LOADing data from a file? I have no problem with the format
> MySQL saves the
> date but most spreadsheet
At 08:39 PM 10/14/2006, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date fields
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date fields in the format -MM-DD even if I formated the f
idth char fields.
So, I am eager to see if this sorting idea helps any.
--
George
>>>-Original Message-
>>>From: Dan Buettner [mailto:[EMAIL PROTECTED]
>>>Sent: Friday, August 18, 2006 3:53 PM
>>>To: George Law
>>>Cc: MYSQL General List
&
George, for raw speed into a MyISAM table, I think you'll find it hard
to beat LOAD DATA INFILE, especially if you disable keys before and
re-enable afterwards (which is not unlike what your friend proposes -
creating the index in a more efficient fashion). I'd be interested to
hear h
r [mailto:[EMAIL PROTECTED]
>>>Sent: Friday, August 18, 2006 1:40 PM
>>>To: George Law
>>>Cc: MYSQL General List
>>>Subject: Re: sorting datafile for "load data infile"
>>>
>>>George, I've not heard of that technique - "sorting
me time at the spent updating
indexes. Overall it can be faster. From
http://dev.mysql.com/doc/refman/5.0/en/load-data.html :
If you use LOAD DATA INFILE on an empty MyISAM table, all non-unique
indexes are created in a separate batch (as for REPAIR TABLE).
Normally, this makes LOAD DATA INFILE
prevent mysql
from having to jump around as much.
What I have is a raw data file that I pre-process to create 3 separate
tab delimited files, which are then loaded into mysql using "load data
infile"...
I am working with a table with a primary key consisting of 2 fields.
|
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 th
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 newline
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 represented by '
MySQL has been updating the table's
index for the past several hours as part of the Load Data Infile process.
Is there any way to speed this up? I'm using MySIAM tables in v4.1.10.
Here are the settings I'm using. Is there anything in there that will
speed up the re-
At 03:56 AM 7/29/2006, C.R.Vegelin wrote:
Hi Mike,
Try the following:
ALTER TABLE tblname DISABLE KEYS;
LOAD DATA INFILE ...
ALTER TABLE tblname ENABLE KEYS;
hth, Cor
Hi,
I had tried that on another (larger) t year, and it does of course
load the data slightly faster because the
Hi Mike,
Try the following:
ALTER TABLE tblname DISABLE KEYS;
LOAD DATA INFILE ...
ALTER TABLE tblname ENABLE KEYS;
hth, Cor
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, July 29, 2006 4:50 AM
Subject: Re: Way too slow Load Data Infil
I ran a file monitor and it appears MySQL has been updating the table's
index for the past several hours as part of the Load Data Infile process.
Is there any way to speed this up? I'm using MySIAM tables in v4.1.10. Here
are the settings I'm using. Is there anything in there tha
I executed a "Load Data Infile" 24 hours ago and its still running. Yikes!
I have 6 of these tables to load and at this rate it will take forever. Can
someone please run through my Status variables and let me know if there is
a way I can optimize it? (These values are current with the
I'm replacing 14 million rows of data using "Load data infile replace" and
it is taking forever to complete. I killed it after 6.2 hours on an AMD
3500 machine. I then deleted all the data from the table and used "Load
data infile ignore" and it completed quite quickly
Sheeri,
Wow. That was my first forum email and I thought it would go unnoticed. I
sure was wrong.
You are exactly right, because apparently with LOAD DATA INFILE, everything
in the file is treated as a string. I'm using PHP to create the text file,
so I tried PHP's pack() functio
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
000002
mysql> load data in
Hi. I'm using MySQL 5.0.18, and I'm trying to use LOAD DATA INFILE into tables
that have BIT(8) columns. No matter
what format I use, the result is not what I expect (see example below.) Anyone
know how to properly format the data for loading into a BIT column? Thanks!
$ cat /tmp/bi
Rock*Texas 78682" áDELL á TX áEastern
Operations
á áá
Is there any way I can set the FIELD TERMINATOR and LINE TERMINATOR to
include this character so my LOAD DATA INFILE works?
I tried using a variable and mysql didn't like it:
set @field:=concat(
Do chmod -R 755 on datapath
Thanks
Praj
- Original Message -
From: "Jay Paulson (CE CEN)" <[EMAIL PROTECTED]>
To:
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
o properly execute what it needed. So if you run into this
simply check each directory within the path and make sure of it's
settings"
-Original Message-
From: Jay Paulson (CE CEN) [mailto:[EMAIL PROTECTED]
Sent: Wed 1/11/2006 11:17 AM
To: mysql@lists.mysql.com
Subject: LO
I'm creating a file via PHP after getting information from a log file. I
create a new file for data import into a table in MySQL. For some reason now
I'm getting this error below. I have no clue what it means. I've checked the
file and it is all there and I've even changed the permissions on
AIL PROTECTED]> wrote:
>
>List: MySQL General Discussion« Previous MessageNext Message »
>From: George Law Date: January 6 2006 11:01pm
>Subject: Sorry for my n00bie question - mysql 5.0.18 with load data
>infile
>Get Plain Text
>
>H
ead only". The completed cdrs have fields that get updated at a later
time.
There seemed to be a lot of processes out there waiting on table locks
when this was a myisam table.
The performance of the 'load data infile' command seems like it is
taking way too long.
(dates are just
2005 8:12 AM
To: mysql@lists.mysql.com
Subject: LOAD DATA INFILE Syntax
Hi mysql-list,
I just installed,
++
| version() |
++
| 5.0.16-log |
++
Here is what I am testing out: (simple table and data)
% echo 'a b c d' > testfile
mysql> CREATE
Hi mysql-list,
I just installed,
++
| version() |
++
| 5.0.16-log |
++
Here is what I am testing out: (simple table and data)
% echo 'a b c d' > testfile
mysql> CREATE TABLE `test` (
-> `fe` VARCHAR( 2 ),
-> `fi` VARCHAR( 2 ),
-> `fo` VARCHAR( 2
-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 s
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 ?
PROTECTED]
> Sent: 12/01/2005 04:55 AM
> To:
> Subject: LOAD DATA INFILE (url)
>
> 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
time thing?
-
Sent from my NYPL BlackBerry Handheld.
- Original Message -
From: Test USER [EMAIL PROTECTED]
Sent: 12/01/2005 04:55 AM
To:
Subject: LOAD DATA INFILE (url)
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 LOC
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 ?
-
At 11:15 PM 11/19/2005, Rhino wrote:
- Original Message - From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:16 PM
Subject: Is Load Data Infile or Update is faster?
I am doing a balance line comparison between the rows of an existing
table and
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:16 PM
Subject: Is Load Data Infile or Update is faster?
I am doing a balance line comparison between the rows of an existing table
and a text file that has newer da
. The
table has around 25 million rows and usually only 1% of the table needs to
be compared.
I've found 2 ways to update the table with the new values:
1) I could write the new values to a text file and then use "Load Data
InFile REPLACE ..." which will replace the existing ro
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.
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 se
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 th
Hi folks,
I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the
following command
LOAD DATA INFILE '1037021.pdf' INTO TABLE complete FIELDS TERMINATED BY
'%%EOF' (d_c)
in the Query Browser 1.1.17, MySQL 5.0.15, running on W2K. Field d_c is
d
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
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');
-
FREE E-MA
l.html
'Yemi Obembe wrote:
> i'm having a problem with the load data infile command...i'm actually running
> the script from a php script that goes this way:
> mysql_connect("localhost", "$user", "$pass");
> mysql_select_db("ng&quo
in
how php parses scripts and such.
-Sheeri
On 10/20/05, 'Yemi Obembe <[EMAIL PROTECTED]> wrote:
> i'm having a problem with the load data infile command...i'm actually running
> the script from a php script that goes this way:
> mysql_connect("localhost",
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
the script and the txt file movies.txt reside on the same directory. runnign
the page, i get the error: The used command is not allowed with this MySQL
v
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
the script and the txt file movies.txt reside on the same directory. runnign
the page, i get the error: The used command is not allowed with this MySQL
v
Dear Michael,
thank you for your response.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
How does that happen? I take it you are adding the imported data into an
already populated table.
True, that's what I meant to say.
Don't alter the keys for th
Gerhard Prilmeier wrote:
Hello,
I use tables with one primary key (which is the only unique key). I'd
like to export data from such a table to a file, and then import it on
another machine.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
How does that happe
Hello,
I use tables with one primary key (which is the only unique key). I'd like
to export data from such a table to a file, and then import it on another
machine.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
MySQL gives me the choice of whether to
1.
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, s
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
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 supporte
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 command:
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 command:
LOAD DATA LOCAL INFILE 'C:\\PHP\\FL_DECI.txt'
INTO TABLE locations2
FIELDS TERMINATED BY '|'
LINE
Hallo Thorsten,
Op 14 Sep 05 schreef Thorsten Moeller aan MySQL Mailinglist:
TM> i am trying to load a csv file with "LOAD DATA INFILE". This File
TM> contains columns with decimal values with the german comma instead of
TM> the dot as separator (e.g. 3.20 is 3,20). Is
Hi,
i am trying to load a csv file with "LOAD DATA INFILE". This File
contains columns with decimal values with the german comma instead of
the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle
this during or immediately before LOAD with MySQL Commands/Tools. Now w
1 - 100 of 507 matches
Mail list logo