OceanBase 算術(shù)運(yùn)算符

以下為所有算術(shù)運(yùn)算符列表：

整數(shù)除法遵循如下原則：

• 商數(shù)不論正負(fù)，統(tǒng)一向 0 取整。

• 余數(shù)正負(fù)與被除數(shù)相同。

例如：

obclient> SELECT (-7) DIV (3.6), (-7) MOD (3.6);
+----------------+----------------+
| (-7) DIV (3.6) | (-7) MOD (3.6) |
+----------------+----------------+
|             -1 |           -3.4 |
+----------------+----------------+
1 row in set (0.01 sec)

obclient> SELECT (-7) DIV (-3.4), (-7) % (-3.4);
+-----------------+---------------+
| (-7) DIV (-3.4) | (-7) % (-3.4) |
+-----------------+---------------+
|               2 |          -0.2 |
+-----------------+---------------+
1 row in set (0.02 sec)