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 handle
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
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.
---
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 knowing just
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 ''
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 Ignore
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 that,
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/040412
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
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
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
13 matches
Mail list logo
