Inerting/selecting GUIDs into/from MySQL

gistfile1.txt

mysql>CREATE TABLE jive (uuid CHAR(16) BINARY);
Query OK, 0 rows affected (0.02 sec)

mysql> select UUID();
+--------------------------------------+
| UUID()                               |
+--------------------------------------+
| 519718a1-e8ab-11e1-8803-080027e1c419 |
+--------------------------------------+
1 row in set (0.00 sec)


mysql> INSERT INTO jive(uuid) VALUES(UNHEX(REPLACE('519718a1-e8ab-11e1-8803-080027e1c419', '-', '')));
Query OK, 1 row affected (0.00 sec)


mysql> SELECT HEX(uuid) FROM jive;
+----------------------------------+
| HEX(uuid)                        |
+----------------------------------+
| 519718A1E8AB11E18803080027E1C419 |
+----------------------------------+
1 rows in set (0.00 sec)