Ho everyone

I have a column in a table defined as float

mynumber float(20,2)

if we say mynumber column in a row is 1000000 ,  when I run this SQL :

UPDATE Table SET mynumber=mynumber-100.15

the mynumber column will be 999900 not 999899.85

what is the problem ?



--
echo "Hello World :)"

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to