下面这个语句会得到什么呢?
select 14/31763
在MySQL上查询得到:
实际计算器计算的结果:
黑人问号脸:
google了半天,试着寻找各种关键词:“how to increase precision of two integers division in mysql”,“mysql parameters about division precision” ,终于找到一篇文档。
解决办法调整一下参数:
mysql> show variables like 'div_precision_increment'
-> \G
*************************** 1. row ***************************
Variable_name: div_precision_increment
Value: 4
1 row in set (0.13 sec)
mysql> set div_precision_increment=6;
Query OK, 0 rows affected (0.01 sec)
mysql> select 14/31763;
+----------+
| 14/31763 |
+----------+
| 0.000441 |
+----------+
1 row in set (0.00 sec)