.1 can not be represented exactly on a binary machine. there must be an
approximation stored in the fractional bits of the floating point
representation. there are more fractional bits in a double than in a float.
so the approximation is better. see the user manual for exact sizes.
At 12:51 PM
Dave Jolly wrote:
>
> Hi,
>
> There seems to be a round-off problem with FLOAT.
>
> Here's a scenario to replicate it...
>
> <-->
> $ mysql
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1149 to server version: 3.23.41
>
> Type 'help;'
