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 :)"
