Thanks Dan & Mos I have many tables that use float (in production database), if I convert all of the float column to DOUBLE or DECIMAL (using alter ), is there any impact or anything I should know that could happen to me ?
is there any page that describe the differences between FLOAT, DECIMAL and DOUBLE in MySQL 5.0.* ? Thanks On 11/18/06, mos <[EMAIL PROTECTED]> wrote:
At 03:29 PM 11/17/2006, Ahmad Al-Twaijiry wrote: >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 ? Ho Ho Ho, Float only uses 4 bytes and does not have much precision so you'll get rounding. Try DOUBLE instead. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- echo "Hello World :)" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
