From: Dan Nelson
Date: November 17 2006 10:48pm
Subject: Re: float numbers
List-Archive: http://lists.mysql.com/mysql/203422
Message-Id: <20061117224812.GD7333@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Nov 18), Ahmad Al-Twaijiry said:
> 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.* ?

In addition to the url I listed in my first post

 http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

there's also:

 http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.html
 http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
 http://dev.mysql.com/doc/refman/5.0/en/precision-math.html

-- 
	Dan Nelson
	dnelson@stripped