At 13:46 -0700 5/30/06, Jeremy Cole wrote:
Hi,
You don't need to take it to 16 digits :
mysql 4 :
select 1/666;
+-------+
| 1/666 |
+-------+
| 0.00 |
+-------+
mysql 5.0.18:
select 1/666;
+--------+
| 1/666 |
+--------+
| 0.0015 |
+--------+
Actually, this is an entirely different case, it's a matter of where
MySQL decides how many digits to show by default. You can influence
that quite easily:
mysql> select 1.000000000/666;
+-----------------+
| 1.000000000/666 |
+-----------------+
| 0.00150150150 |
+-----------------+
1 row in set (0.00 sec)
It's also influenced by the div_precision_increment system variable,
which is described on this page:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
