DIV

Syntax

DIV

Description

Integer division. Similar to FLOOR(), but is safe with BIGINT values. Incorrect results may occur for non-integer operands that exceed the 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 | +-----------+

See Also

• Division operator

• Operator Precedence

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