Originariamente inviato da ptransidico
si mi da errore
ma la cosa strana è che se provo con >999.9 funziona
float considera anche i numeri che non vedi.... e quindi = "deve" essere tale per tutto il valore.

#

If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you can't use equality (=) comparisons. This problem is common in most computer languages because not all floating-point values can be stored with exact precision. In some cases, changing the FLOAT to a DOUBLE fixes this. See Section B.1.5.8, “Problems with Floating-Point Comparisons”.

Similar problems may be encountered when comparing DECIMAL values prior to MySQL 5.0.3.
http://dev.mysql.com/doc/refman/5.0/...ric-types.html
http://dev.mysql.com/doc/refman/5.0/...hing-rows.html