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

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: Mysql Mod Function  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):