MOD(N,M)

MOD(N,M), N % M, N MOD M

Syntax

MYSQL Copy

SELECT MOD(234, 10);
4
SELECT 253 % 7;
1
SELECT MOD(29,9);
2
SELECT 29 MOD 9;
2

Contoh

Example

Modulo operation. Returns the remainder of N divided by M. Returns NULL if M or N is NULL.

MYSQL Copy

SELECT MOD(234, 10);
4
SELECT 253 % 7;
1
SELECT MOD(29,9);
2
SELECT 29 MOD 9;
2

Example 2

This function is safe to use with BIGINT values.

MYSQL Copy

SELECT MOD(34.5,3);
1.5