DIV() Function in MySQL

DIV() function :
This function in MySQL is used to return a quotient (integer) value when integer division is done. For example, when 7 is divided by 3, then 2 will be returned.

Syntax :

SELECT x DIV y;

Parameter :
This method accepts two parameters as given below as follows.

• x – Specified dividend which will be divided by y.
• y – Specified divisor which will divide x.

Returns :
It returns a quotient (integer) value when integer division is done.

Example-1 :
Getting quotient 2 when 7 is divided by 3.

SELECT 7 DIV 3;

Output :

2

Example-2 :
Getting quotient 1 when 4 is divided by 4.

SELECT 4 DIV 4;

Output :

1

Example-3 :
Getting quotient 0 when 2 is divided by 4. Here dividend is less than divisor that is why 0 is returned.

SELECT 2 DIV 4;

Output :

0

Application :
This function is used to return a quotient (integer) value when integer division is done.