MySQL DIV OPERATOR

DIV OPERATOR

MySQL div operator is used for integer division. It divides one number by another and returns the largest integer value that is less than or equal to the result.

This function is useful in -

• The DIV operator provides a result by ensuring that the result is an integer.
• The DIV operator discards the remainder of a division operation, which can be useful in scenarios where fractional results are not meaningful or desired.
• The DIV operator always rounds down to the nearest integer.
• In programming and scripting, the DIV operator is valuable for controlling loops and iterations, especially when handling arrays or collections of data.
• In server setups and distributed computing environments, the DIV operator is used to distribute tasks or requests across multiple servers evenly.
• In SQL queries, the DIV operator can be used to optimize operations that require integer results, improving the efficiency of the query execution plan.

Syntax:

expression DIV num 

Arguments:

MySQL Version: 8.0

Pictorial presentation of MySQL DIV() operator

Example of MySQL DIV() OPERATORS

Code:

SELECT 12 DIV 3;

Explanation:

The above MySQL statement divides 12 by 3.

Output:

mysql> SELECT 12 DIV 3;
+----------+
| 12 DIV 3 |
+----------+
|        4 | 
+----------+
1 row in set (0.02 sec)

All Mathematical Functions

Previous: DEGREES()
Next: DIVISION