Conversion

UUID_SHORT

MySQL

Menghasilkan 64-bit unsigned integer yang unik. Lebih cepat dan compact dari UUID().

Tipe hasil: BIGINT UNSIGNEDDiperbarui: 7 Jan 2026

Syntax

SQL

UUID_SHORT()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT UUID_SHORT() AS short_id;

Generate 64-bit unique ID.

Hasil

short_id: 101232134567891234

SQL

1 INSERT INTO events (id, event_name)
2 VALUES (UUID_SHORT(), 'New Event');

Menggunakan UUID_SHORT sebagai ID.

Hasil

(inserted with unique ID)

SQL

1 SELECT UUID_SHORT() AS id1,
2        UUID_SHORT() AS id2,
3        UUID_SHORT() AS id3;

Generate multiple IDs sekaligus.

Hasil

(three unique IDs)

1	INSERT INTO events (id, event_name)
2	VALUES (UUID_SHORT(), 'New Event');