# **DIV**

## **Operator Description**

The `DIV` operator is used for integer division.

If both operand values are non-integer types, the operand values are converted to `DECIMAL` and the division is performed using the `DECIMAL` algorithm before converting the result to `BIGINT`. An error occurs if the result is outside the `BIGINT` range.

## **Grammar Structure**

```sql
SELECT value1 DIV value2;
```

```sql
SELECT column1 DIV column2... FROM table_name;
```

## **Example**

```text
mysql> SELECT 5 DIV 2, -5 DIV 2, 5 DIV -2, -5 DIV -2;
+------------------------------------------------------------------------------------------------------------------------------
| 5 div 2 | -5 div 2 | 5 div -2 | -5 div -2 |
+------------------------------------------------------------------------------------------------------------------------------
| 2 | -2 | -2 | 2 |
+------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
```

```text
create table t2(c1 int, c2 int);
insert into t2 values (-3, 2);
insert into t2 values (1, 2);

mysql> select c1 DIV 3 from t2;
+-------------+
| c1 div 3 |
+-------------+
| -1 |
| 0 |
+-------------+
2 rows in set (0.00 sec)

mysql> select c1 DIV c2 from t2;
+---------------+
| c1 div c2 |
+---------------+
| -1 |
| 0 |
+---------------+
2 rows in set (0.00 sec)
```