By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.36 |
CREATE TABLE foo (
b BINARY(16) DEFAULT (UUID_TO_BIN(UUID()))
);
INSERT INTO foo () VALUES();
INSERT INTO foo () VALUES(DEFAULT);
SELECT BIN_TO_UUID(b) FROM foo;
| BIN_TO_UUID(b) |
|---|
| da9c52ff-f5b8-11ef-829d-af0b29aeec96 |
| da9c8093-f5b8-11ef-829d-af0b29aeec96 |