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)

Related Tags for Mysql Mod Function:
sql, mysql, c, ide, div, function, fun, io, sed, vi, return, id, ai, unc, to, e, main, use, in, mod, m, em, func, s, urn, my, is, iv, divide, s, s, th, nd, on, o

«Previous Index Next»