MySQL Tutorial/Math Numeric Functions/MOD
Содержание
(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.
MOD() also works on values that have a fractional part and returns the exact remainder after division:
<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>
