w3resource

MySQL DIV OPERATOR

DIV OPERATOR

MySQL div operator is used for integer division.

Syntax:

expression DIV num 

Arguments:

Name Description
expression An expression which contains the dividend.
num Divisor.

Pictorial presentation of MySQL DIV() operator

pictorial presentation of MySQL DIV() function

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

MySQL Mathematical Functions, slide presentation

Previous: DEGREES()
Next: DIVISION



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook