List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 17 2006 10:48pm
Subject:Re: float numbers
View as plain text  
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
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