Re: rounding behaviour

David Garamond wrote: mysql> select 1/29; +--+ | 0.03 | +--+ mysql> select 100.0*1/29; ++ | 3.448 | ++ mysql> select 1/29*100.0; ++ | 3.45 | ++ sorry for the previous post, misleading problem statement. the exact problem for m

rounding behaviour

hi, mysql> select 1/29; +--+ | 1/29 | +--+ | 0.03 | +--+ 1 row in set (0.00 sec) mysql> select 100.0*1/29; ++ | 100.0*1/29 | ++ | 3.448 | ++ 1 row in set (0.00 sec) mysql> select 1/29*100.0; ++ | 1/29*100.0 | ++ |