w3resource
MYSQL Tutorial

MySQL DIVISION operator

DIVISION operator

MySQL division operator is used for integer division.

Syntax:

num / num

Arguments

Name Description
num Dividend.
/ Division operator.
num Divisor.

Example of MySQL DIVISION() function

Code:

SELECT 12 / 3;

Explanation

The above MySQL statement divides 12 by 3.

Sample Output:

mysql> SELECT 12 / 3;
+--------+
| 12 / 3 |
+--------+
| 4.0000 | 
+--------+
1 row in set (0.00 sec)

All Mathematical Functions>

MySQL Mathematical Functions, slide presentation

Previous: DIV
Next: EXP()