Hallo,
I get data with a format that I can't choose. The fields are enclosed
in double quotes ("), separated by commas (,). The main problem is that
some fields contain amounts with a decimal comma. I have not found a
way yet to load these data properly. Could somebody help me please?>
Groetjes,
Hello Anoop,
On 22 Jun 05, Anoop kumar V wrote to All:
AkV> Are u saying that u have data in a text file and you need to parse
AkV> this and insert them into mysql?
That's what I Ntried to say, yes :) The main problem is the decimal comma
in the amounts.
Regards,
Hans.
jdh dot be
Hallo Anoop,
Op 22 Jun 05 schreef Anoop kumar V aan Jigal van Hemert <[EMAIL PROTECTED]>,:
AkV> Alternatively, you can parse the text files using application logic
AkV> (java, c++, etc) and then after extracting (and cleaning) your data
AkV> insert them into mysql.
I had been thinking about t
Hallo Jigal,
Op 22 Jun 05 schreef Jigal van Hemert aan <[EMAIL PROTECTED]:
JvH> What about reading the data into the table and storing the
JvH> 'amount' in varchar for now. Then you can run an update query in
JvH> UPDATE `table` SET `amount`= REPLACE( `v_amount`, ',' , '.'),
JvH> `v_amount`
Hello,
How can I prevent duplicate entries when I fill the data base with
"load data"? I tried ignore, but that has no effect. Probably I'm
something very elementary, but I'm still learning...
Regards,
Hans.
jdh dot beekhuizen at duinheks dot xs4all dot nl
--- GoldED+/LNX 1.1.5/04041
Hello Mike,
On 27 Jun 05, mos wrote to mySQL list:
>> How can I prevent duplicate entries when I fill the data base with
>> "load data"? I tried ignore, but that has no effect.
m> Ignore/Replace will only work on Unique keys and I bet your key is
m> not unique. If you make it unique, then Ign
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 b
Hallo,
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
Is this possible, and, if yes, how?
Groetjes,
Hans.
--- GoldED+/LNX 1.1.5/050823
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Maili
Hallo Jasper,
Op 29 Aug 05 schreef Jasper Bryant-Greene aan mysql:
>> I would like a single row in a table, and not more than one, to be
>> used as a preferred value in another application.
JBG> add a column 'preferred', tinyint(1) NOT NULL.
Thank you!
Groetjes,
Hans.
--- GoldED
Hallo Michael,
Op 29 Aug 05 schreef Michael Stassen aan [EMAIL PROTECTED]:
>> >> I would like a single row in a table, and not more than one, to
>> >> be used as a preferred value in another application.
>> JBG> add a column 'preferred', tinyint(1) NOT NULL.
MS> It's hard to say without kn
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 there an option to handl
Hallo,
I'm using MySQL 4.0.23a as found in the SlackWare 10.1 distribution.
As I'm totally new to MySQL I tried tom follow the tutorial from the
manual. When I tried to fill the data base using a text file with the
command
load data local infile '~/temp' into table huisdier;
I got
ERROR 1148: The
Hallo Peter,
Op 30 May 05 schreef Peter aan [EMAIL PROTECTED]:
P> http://dev.mysql.com/doc/mysql/en/load-data-local.html
P> #
P> If LOAD DATA LOCAL INFILE is disabled, either in the server or the
P> client, a client that attempts to issue such a statement receives the
P> following error me
13 matches
Mail list logo
