mysql除法精度
Example:
mysql> lect 1*0.00001;
+-----------+
糖果纸
| 1*0.00001 |
楼一幢
+-----------+
| 0.00001 |
+-----------+
Ok, that looks fine. Let's do the same thing using division:
mysql> lect 1/100000;
+----------+
万圣节活动策划方案
青椒蛋炒饭
| 1/100000 |
+----------+
| 0.0000 |
+----------+
Oops! What happened?
The issue is that the maximum precision of the result value depends on the number of decimal places in the arguments. Since the cond version us two whole numbers, the result us the default number of decimal places, which is 4. So you really have to take care to make sure you're getting the precision you want out of your math operations!
To MySQL's credit, (however, I maintain it's still a bit troublesome becau how often would you expect the division operator to have a list of instructions and caveats?)
There are at least a couple simple solutions:
mysql> SELECT CAST(1/100000 AS DECIMAL(8,5) );查看的近义词
+---------------------------------+
| CAST(1/100000 AS DECIMAL(8,5) ) |
+---------------------------------+由衷意思
| 0.00001 |
+---------------------------------+
Or
mysql> SET div_precision_increment=5;
mysql> SELECT 1/100000;
+----------+
| 1/100000 |
松下zs3>计较+----------+
| 0.00001 |
+----------+
