Cory> The field contains 1234.5678, MySQL returns 1234.57, don't want that!
select Round (field/1000, 4) from ...
Ivan
__
One World, one Web, one Program
-- Microsoft promotional ad
Ein Volk, ein Reich, ein Fuhrer
-- Adolf Hi
Hi,
I am trying select field / 1 as Number from table1 where id = 1;
I don't want any rounding taking place, but MySQL is currently doing it.
How can I ask for a specific number of digits with division?
The field contains 1234.5678, MySQL returns 1234.57, don't want that!
Tha
In relational algebra, queries using the expression "for all" are usually
handled with the division operation. What is the equivalent of the
division operation in mysql (in sql, it's "where n