-+
| 4.94 |
+--+
1 row in set (0.00 sec)
==>> >> FLOAT (10,2)
Regards,
Almar van Pel
-Oorspronkelijk bericht-
Van: M. A. Alves [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag, december 13, 2001 16.47
Aan: Wojciech Dr¹¿ek
CC: [EMAIL PROTECTED]
Onderwerp: Re:
On Thu, 13 Dec 2001, [iso-8859-2] Wojciech Dr±¿ek wrote:
>
> I wonder if it is only question of configuration but my MySQL server has
> problems with suming of float values.
>
> create table ft (id INT AUTO_INCREMENT, val FLOAT, PRIMARY KEY(id));
> insert ft(val) values('3.4');
> insert ft(val) va
Hi,
This is what I got on a Windows 2000 platform
mysql> create table ft (id INT AUTO_INCREMENT, val FLOAT, PRIMARY KEY(id));
Query OK, 0 rows affected (0.01 sec)
mysql> insert ft(val) values('3.4');
Query OK, 1 row affected (0.00 sec)
mysql> insert ft(val) values('0.3');
Query OK, 1 row a
