Conversion

UUID

MySQL

Menghasilkan Universal Unique Identifier (UUID) versi 1. Format: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.

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

Syntax

SQL

UUID()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT UUID() AS new_uuid;

Generate UUID baru.

Hasil

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

SQL

1 INSERT INTO transactions (transaction_id, amount)
2 VALUES (UUID(), 150.00);

UUID sebagai unique transaction ID.

Hasil

(inserted with unique UUID)

SQL

1 UPDATE users
2 SET session_token = UUID()
3 WHERE id = 1;

Generate unique session token.

Hasil

(session updated with UUID)

GENERATE_UUID

BigQuery

1	INSERT INTO transactions (transaction_id, amount)
2	VALUES (UUID(), 150.00);