Conversion

UUID_TO_BIN

MySQL

Mengkonversi UUID string ke format BINARY(16) untuk storage yang lebih efisien.

Tipe hasil: BINARY(16)Diperbarui: 7 Jan 2026

Syntax

SQL

UUID_TO_BIN(uuid_string[, swap_flag])

uuid_stringVARCHAR(36)wajib

UUID dalam format string

swap_flagINTopsional

1 = swap time-low dan time-high untuk indexing

SQL

1 SELECT UUID_TO_BIN('550e8400-e29b-41d4-a716-446655440000') AS bin_uuid;

Konversi UUID ke binary.

Hasil

bin_uuid: (16 bytes binary)

SQL

1 INSERT INTO entities (id, name)
2 VALUES (UUID_TO_BIN(UUID(), 1), 'Entity Name');

Store UUID secara efisien dengan swap.

Hasil

(efficient binary storage)

SQL

1 SELECT * FROM entities
2 WHERE id = UUID_TO_BIN('550e8400-e29b-41d4-a716-446655440000', 1);

Query menggunakan binary UUID.

Hasil

(entity found)

1	INSERT INTO entities (id, name)
2	VALUES (UUID_TO_BIN(UUID(), 1), 'Entity Name');

1	SELECT * FROM entities
2	WHERE id = UUID_TO_BIN('550e8400-e29b-41d4-a716-446655440000', 1);