Mysql Mod Function

Mysql Mod Function is used to return the remainder of N divided by M. The
Syntax used for Mysql Mod Function is given below:
SYNTAX:-Select MOD(N,M);
Returns the remainder of N divided by M.
Query for Modulo operation:
The Query given below MOD is used to return the remainder of 34
divided by 3 as fieldname 'MODULUS'.
mysql> SELECT MOD(34,3)as MODULUS;
|
Output:-
+---------+
| MODULUS |
+---------+
| 1 |
+---------+
1 row in set (0.00 sec)
|
Query:-
mysql> select 11 mod 3 as MODULUS;
|
Output:-
+---------+
| MODULUS |
+---------+
| 2 |
+---------+
1 row in set (0.00 sec)
|

|