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/