/

Division:

Syntax

MYSQL Copy

SELECT 3/5;
0.60

Examples

Example

Division by zero produces a NULL result:

MYSQL Copy

SELECT 3/5;
0.60

Example 2

A division is calculated with BIGINT arithmetic only if performed in a context where its result is converted to an integer.

MYSQL Copy

SELECT 102/(1-1);
NULL