MySQL DIV OPERATOR

DIV OPERATOR

MySQL div operator is used for integer division.

Syntax:

expression DIV num 

Arguments:

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.

Sample Output:

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

All Mathematical Functions

Previous: DEGREES()
Next: DIVISION