BIT_AND() function in MySQL

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.

BIT_AND() function in MySQL

K

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

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

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

FIELD() Function in MySQL

FIELD() function : This function in MySQL is used to return the index position of a specified value in a list of given values. For example, if the given list is ("3", "1", "2") and the value is "1" for which index position is going to be search, then this function will return 2 as the index position

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

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

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

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

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

BIT_OR() Function in MySQL

BIT_OR() function in MySQL is used to return the bitwise OR of all bits in a given expression. It first converts all decimal values into binary values, and then perform bitwise or operation on those binary values. Syntax : BIT_OR(expr) Parameter : This method accepts only one parameter. expr - Input