Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

DIV

Perform integer division. This operator divides one number by another and returns the integer result, discarding any remainder.

Syntax

DIV

Description

Integer division. The fractional part of the result is discarded, so the result is truncated toward zero. This differs from FLOOR() for negative results: -22 DIV 7 returns -3, while FLOOR(-22/7) returns -4. DIV is safe with BIGINT values. Incorrect results may occur for non-integer operands that exceed the BIGINT range.

Dividing by zero returns NULL. When the ERROR_FOR_DIVISION_BY_ZERO SQL mode is enabled, as it is by default, a division by zero also produces a warning. If strict mode is also enabled, an INSERT or UPDATE that divides by zero fails with an error instead.

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 |
+-----------+

See Also

This page is licensed: GPLv2, originally from fill_help_tables.sql

Last updated

Was this helpful?