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 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 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,
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,
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
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
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
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`
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
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,
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,
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
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,
I'm totally new to MySQL or any other data bases...
I installed MySQL 4.0.15a as supplied with the SlackWare 9.1 Linux
distribution. The only documentation supplied are the Reference Manual en
the man pages. But the Reference Manual is a little bit too touch for me. I
managed to get m
14 matches
Mail list logo