MYSQL UUID

MySQL UUID example

Let’s take a look at an example of using UUID as the primary key.

The following statement creates a new table named customers:

1 2 3 4

CREATE TABLE customers (     id BINARY(16) PRIMARY KEY,     name VARCHAR(255) );

To insert UUID values into the id column, you use UUID() and UUID_TO_BIN() functions as follows:

1 2 3 4

INSERT INTO customers(id, name) VALUES(UUID_TO_BIN(UUID()),'John Doe'),       (UUID_TO_BIN(UUID()),'Will Smith'),       (UUID_TO_BIN(UUID()),'Mary Jane');

To query data from a UUID column, you use BIN_TO_UUID() function to convert binary format to human-readable format:

1 2 3 4 5

SELECT     BIN_TO_UUID(id) id,     name FROM     customers;

http://www.mysqltutorial.org/mysql-uuid/