On fredag, dec 27, 2002, at 16:19 Europe/Copenhagen, Paul DuBois wrote:
At 15:18 +0100 12/27/02, Jonas C. Voss wrote:
Actually, I tried a plethora of formats including the following:
1139
113900
1.139,00
1,139.00
1139,00
1139.00
But MySQL interprets them all as 1.13.
Based on that last stat
At 15:18 +0100 12/27/02, Jonas C. Voss wrote:
Hi all,
I have a text-file containing products and their prices for a small
shop. I upload and insert the text-file into a MySQL table using the
LOAD DATA LOCAL INFILE command, and it really works a treat.
My problem is that when inserting prices o
Hi all,
I have a text-file containing products and their prices for a small
shop. I upload and insert the text-file into a MySQL table using the
LOAD DATA LOCAL INFILE command, and it really works a treat.
My problem is that when inserting prices of more than one thousand, the
field it gets in
