div_precision_increment 该变量说用用/操作符执行除操作的结果可增加的精确度的位数。默认值是4。最小和最大值分别为0和30.下面的示例说明了增加默认值得结果。
mysql> SELECT 1/7;
+--------+
| 1/7 |
+--------+
| 0.1429 |
+--------+
mysql> SET div_precision_increment = 12;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT 1/7;
+----------------+
| 1/7 |
+----------------+
| 0.142857142857 |
+----------------+
1 row in set (0.00 sec)