Conversion

BIN_TO_UUID

MySQL

Mengkonversi BINARY(16) UUID ke format string. Kebalikan dari UUID_TO_BIN().

Tipe hasil: VARCHAR(36)Diperbarui: 7 Jan 2026

Syntax

SQL

BIN_TO_UUID(binary_uuid[, swap_flag])

binary_uuidBINARY(16)wajib

UUID dalam format binary

swap_flagINTopsional

1 jika stored dengan swap

SQL

1 SELECT BIN_TO_UUID(id, 1) AS uuid_string
2 FROM entities;

Konversi binary UUID ke string untuk display.

Hasil

uuid_string: 550e8400-e29b-41d4-a716-446655440000

SQL

1 SELECT BIN_TO_UUID(id, 1) AS id,
2        name,
3        email
4 FROM users;

Output UUID readable untuk API.

Hasil

(readable UUID in response)

SQL

1 SELECT BIN_TO_UUID(session_id, 1) AS session,
2        created_at
3 FROM sessions
4 ORDER BY created_at DESC
5 LIMIT 10;

View sessions dengan readable UUID.

Hasil

(sessions with UUID strings)

1	SELECT BIN_TO_UUID(session_id, 1) AS session,
2	created_at
3	FROM sessions
4	ORDER BY created_at DESC
5	LIMIT 10;