Syntax
MOD(N,M)
Purpose
MOD() returns the remainder of a number divided by another number. MOD(N,M), N % M, and N MOD M are equivalent.
MOD() works also for numeric values with a fractional part and returns the exact remainder after the division operation.
If either of N or M is NULL, the return value is NULL. If M is 0, the return value is also NULL.
Examples
obclient> SELECT MOD(29,19), 29 MOD 19, 29 % 19;
+------------+-----------+---------+
| MOD(29,19) | 29 MOD 19 | 29 % 19 |
+------------+-----------+---------+
| 10 | 10 | 10 |
+------------+-----------+---------+
1 row in set
