DIV() Function in MySQL

Last Updated : 10 Dec, 2020

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 :

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

SELECT 4 DIV 4;

Output :

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 :

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

AVG() Function in MySQL

Kanchan_Ray

Improve

Article Tags :

Similar Reads

DAY() Function in MySQL

DAY() function : This function in MySQL is used to return the day of the month for a specified date (a number from 1 to 31). This function equals the DAYOFMONTH() function. Syntax : DAY(date) Parameter : This method accepts a parameter which is illustrated below : date : Specified date to extract th

1 min read

AVG() Function in MySQL

AVG() function : This function in MySQL is used to return the average value of the specified expression. Features : This function is used to find the average value of the specified expression.This function comes under Numeric Functions.This function accepts only one parameter namely expression.This

2 min read

BIT_AND() function in MySQL

BIT_AND() : This function in MySQL is used to return the Bitwise AND of all bits in a given expression. It first converts all decimal values into binary values, and then perform bitwise and operation on those binary values. The BIT_AND() function works by performing a bitwise AND operation on each p

3 min read

FIELD() function in MySQL

FIELD() : This function helps in returning the position of a value in the given value list. If the user passes string values as the argument of FIELD() function, then the search will be performed as string values. And, If the user passes numeric values as the argument of FIELD() function, then searc

2 min read

COT() Function in MySQL

COT() function : This function in MySQL is used to return the cotangent of a specified number. If the specified number is 0, an error or NULL will be returned. In a right triangle, the cotangent of an angle is the length of it's adjacent side divided by the length of the opposite side. Similarly, th

1 min read

ELT() Function in MySQL

In this article, we are going to cover ELT function with examples. In ELT function, number field will state that how many strings will be there. ELT function in MySQL is used to returns the string which is at index number specified in the argument list. In this function there is number field and str

1 min read

ASCII() Function in MySQL

In this article, we are going to cover the ASCII function with examples and you will see the ASCII MYSQL query. And will also cover the ASCII code for the given character. Let's discuss one by one. ASCII function in MySQL is used to find the ASCII code of the leftmost character of a character expres

1 min read

EXP() Function in MySQL

EXP() function in MySQL is used to returns E raised to the power of a specified number. Here E(2.718281...) is the base of the natural logarithm. Syntax : EXP(X) Parameter : This method accepts one parameter as mentioned above in the syntax and described below : X â€“ A specified number which will be

2 min read

DATEDIFF() Function in MySQL

DATEDIFF() function in MySQL is used to return the number of days between two specified date values. Syntax: DATEDIFF(date1, date2) Parameter: This function accepts two parameters as given below: date1: First specified datedate2: Second specified date Returns : It returns the number of days between

2 min read

MySQL IF( ) Function

The MySQL IF() function is a control flow function that returns different values based on the result of a condition. IF() Function in MySQLThe IF() function in MySQL returns a value if the condition is TRUE and another value if the condition is FALSE. The MySQL IF() function can return values that c

2 min read