====== MySQL - Storing UUID ======

To store a UUID (128-bit unsigned integer). 128-bits = 16 bytes so use BINARY(16).

<code mysql>
drop table if exists `some_table`;
create table `some_table` (
  uuid binary(16) not null primary key
);
</code>

In order to store the UUID properly, the dashes should be removed and the UUID converted from hexadecimal representation to its binary form.  This could be done in a single step with: <nowiki>UNHEX(REPLACE('id', '-', ''))</nowiki>.  Loading it from the a file could be done this way:

<code bash>
load data infile '/tmp/test.txt' 
into table `some_table`
fields terminated by '\t' 
lines terminated by '\n'
ignore 1 lines
(@var1)
set id = unhex(replace(@var1, '-', ''));
</code>

Of course when retrieving the 'uuid' field, you’ll need to HEX('id').