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)