[HELP] How to insert new record with UUID as PK

[budimanlai]

Hii,

I have a user table with field user_id type is binary(16) as primary key.

i use this sql command to insert a new record

insert into user(id, username, auth_key, password_hash, email, group_id, role_id, status, created_at, updated_at)

value (uuid_in_bin(), ‘itsme’, md5(‘123’), md5(‘123’), ‘me@example.com’, ‘superadmin’, ‘administrator’, ‘active’, now(), now());

where uuid_in_bin() will generate UUID hash in binary(16) format.

uuid_in_bin = UNHEX(REPLACE(UUID(), "-", ""))

my question is how to use uuid_in_bin mysql function in insert/update db command?