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]