в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:50Z

1 версия

Новая страница

== (MOD(4, 0)) will return a null value==



<source lang="sql">
mysql>
mysql> SELECT MOD(4, 0) as Result;
+--------+
| Result |
+--------+
| NULL |
+--------+
1 row in set (0.00 sec)</source>

== MOD(N,0) returns NULL.==

<p>MOD() also works on values that have a fractional part and returns the exact remainder after division:</p>



<source lang="sql">
mysql>
mysql> SELECT MOD(34.5,3);
+-------------+
| MOD(34.5,3) |
+-------------+
| 1.5 |
+-------------+
1 row in set (0.00 sec)
mysql></source>

== MOD(N,M), N % M, N MOD M: modulo operation. returns the remainder of N divided by M.==



<source lang="sql">
mysql>
mysql> SELECT MOD(234, 10);
+--------------+
| MOD(234, 10) |
+--------------+
| 4 |
+--------------+
1 row in set (0.02 sec)
mysql>
mysql> SELECT 253 % 7;
+---------+
| 253 % 7 |
+---------+
| 1 |
+---------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT MOD(29,9);
+-----------+
| MOD(29,9) |
+-----------+
| 2 |
+-----------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT 29 MOD 9;
+----------+
| 29 MOD 9 |
+----------+
| 2 |
+----------+
1 row in set (0.00 sec)
mysql></source>

== The modulo function returns the remainder of two numbers.==



<source lang="sql">
mysql>
mysql>
mysql> SELECT MOD(14, 3) as Result;
+--------+
| Result |
+--------+
| 2 |
+--------+
1 row in set (0.00 sec)
mysql></source>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Math Numeric Functions/MOD - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия