Syntax
------

DIV

Description
-----------

Integer division. Similar to FLOOR(), but is safe with BIGINT values.
Incorrect results may occur for non-integer operands that exceed BIGINT range.

If the ERROR_ON_DIVISION_BY_ZERO SQL_MODE is used, a division by zero produces
an error. Otherwise, it returns NULL.

The remainder of a division can be obtained using the MOD operator.

Examples
--------

SELECT 300 DIV 7;
+-----------+
| 300 DIV 7 |
+-----------+
|        42 |
+-----------+

SELECT 300 DIV 0;
+-----------+
| 300 DIV 0 |
+-----------+
|      NULL |
+-----------+

URL: https://mariadb.com/kb/en/div/