«
»

MySQL inserting UUID to a binary(16) field

It is advantageous to store a UUID (acc to RFC 4122) in a binary(16) field in the database.
It is not hard to create such a table and to insert data into it.

CREATE TABLE IF NOT EXISTS test_table (
  id BINARY(16) NOT NULL,
  name VARCHAR(128) NOT NULL,
  PRIMARY KEY  (id)
) 
 
INSERT INTO test_table (id, name) VALUES
(UNHEX(REPLACE(UUID(),'-','')), 'test1'),
(UNHEX(REPLACE(UUID(),'-','')), 'test2'),
(UNHEX(REPLACE(UUID(),'-','')), 'test3')

Tags:

This entry was posted on Wednesday, June 16th, 2010 at 15:11 and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “MySQL inserting UUID to a binary(16) field”

  1. PHP: converting a uuid stored as BINARY(16) in mysql to RFC 4122 format « Jontas says:
    2010 June 16 at 15:16

    [...] Jontas My notes, todo, random jitter, etc « MySQL inserting UUID to a binary(16) field [...]

Leave a Reply