List:General Discussion« Previous MessageNext Message »
From:Ahmad Al-Twaijiry Date:November 17 2006 10:33pm
Subject:Re: float numbers
View as plain text  
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 <mos99@stripped> 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/mysql?unsub=1
>
>


-- 
echo "Hello World :)"
Thread
float numbersAhmad Al-Twaijiry17 Nov
  • Re: float numbersDan Nelson17 Nov
    • Re: float numbersChris W18 Nov
  • Re: float numbersmos17 Nov
    • Re: float numbersAhmad Al-Twaijiry17 Nov
      • Re: float numbersDan Nelson17 Nov
      • Re: float numbersAsif Lodhi19 Nov
        • Re: float numbersAhmad Al-Twaijiry20 Nov
      • RE: float numbersJerry Schwartz20 Nov
  • ANN: SQL Maestro 6.12 releasedSQL Maestro Group14 Dec