Conversion

BIN

MySQL

Mengkonversi angka desimal ke representasi binary string. Shorthand untuk CONV(num, 10, 2).

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

BIN(num)

numBIGINTwajib

Angka desimal yang akan dikonversi

SQL

1 SELECT BIN(10) AS binary_str;

10 desimal = 1010 binary.

Hasil

binary_str: 1010

SQL

1 SELECT BIN(255) AS binary_str;

255 desimal = 11111111 binary.

Hasil

binary_str: 11111111

SQL

1 SELECT value, BIN(value) AS bits,
2        LENGTH(BIN(value)) AS bit_count
3 FROM numbers;

Analisis representasi binary.

Hasil

(numbers with binary representation)

1	SELECT value, BIN(value) AS bits,
2	LENGTH(BIN(value)) AS bit_count
3	FROM numbers;