MySQL MOD() function

MOD() function

MySQL MOD() returns the remainder of a number divided by another number. This function also works on fractional values and returns the exact remainder. The function returns NULL when the value of divisor is 0.

Syntax:

MOD(N,M), N % M, N MOD M;

Arguments:

Pictorial presentation of MySQL MOD() function

Example of MySQL MOD() function

Code:

SELECT MOD(17,5);

Explanation:

The above statement returns the remainder of 17 divided by 5.

Sample Output:

mysql> SELECT MOD(17,5);
+-----------+
| MOD(17,5) |
+-----------+
|         2 | 
+-----------+
1 row in set (0.00 sec)

Example : MOD() function using MOD keyword

Code:

SELECT 17 MOD 5;

Explanation:

The above MySQL statement returns the remainder of 17 divided by 5. Notice that MOD keyword is used.

Sample Output:

mysql> SELECT 17 MOD 5;
+----------+
| 17 MOD 5 |
+----------+
|        2 | 
+----------+
1 row in set (0.00 sec)

Example : MOD() function using fractional value

Code:

SELECT MOD( 4.567, 2.42 );

Explanation:

The above MySQL statement returns the remainder of the fractional number 4.567 divided by the fractional number 2.42.

Sample Output:

mysql> SELECT MOD( 4.567, 2.42 );
+--------------------+
| MOD( 4.567, 2.42 ) |
+--------------------+
|              2.147 | 
+--------------------+
1 row in set (0.00 sec)

Example : MOD() function using 0(zero) divisor

Code:

SELECT MOD( 13,0 );

Explanation:

The above MySQL statement returns NULL because the value of the divisor is 0.

Sample Output:

mysql> SELECT MOD( 13,0 );
+-------------+
| MOD( 13,0 ) |
+-------------+
|        NULL | 
+-------------+
1 row in set (0.00 sec)

All Mathematical Functions

Previous: LOG10()
Next: OCT()