Re: significant digits for division

2003-07-22 Thread Ivan Cukic
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

significant digits for division

2003-07-21 Thread Twibell, Cory L
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

division

2002-03-16 Thread David C. Eade
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