Math

MOD

MySQL

Mengembalikan sisa bagi (modulo) dari n dibagi m. Tiga sintaks yang setara.

Tipe hasil: Same as inputDiperbarui: 7 Jan 2026

Syntax

SQL

MOD(n, m) | n % m | n MOD m

nnumericwajib

Angka yang dibagi (dividend)

mnumericwajib

Pembagi (divisor)

SQL

1 SELECT MOD(17, 5) AS remainder;

17 dibagi 5 = 3 sisa 2.

Hasil

remainder: 2

SQL

1 SELECT id, name,
2   CASE MOD(id, 2)
3     WHEN 0 THEN 'Even'
4     ELSE 'Odd'
5   END AS parity
6 FROM items;

Mengecek apakah ID ganjil atau genap.

Hasil

(items with odd/even flag)

SQL

1 SELECT *,
2   MOD(ROW_NUMBER() OVER (ORDER BY id), 2) AS stripe
3 FROM products;

Untuk styling zebra-stripe pada tabel.

Hasil

(products with alternating 0/1)

1	SELECT *,
2	MOD(ROW_NUMBER() OVER (ORDER BY id), 2) AS stripe
3	FROM products;