Binary type operation for MySQL

Sample data table:

CREATE TABLE Test_bin (bin_id BINARY (+) not NULL) Engine=innodb;

Insert data (content is a 32-bit UUID string value):

Insert into Test_bin (bin_id) VALUES (Unhex (' fa34e10293cb42848573a4e39937f479 ')), insert into Test_bin (bin_id) VALUES ( Unhex (?)); or INSERT into Test_bin (bin_id) VALUES (x ' fa34e10293cb42848573a4e39937f479 ');

Query data:

SELECT HEX (bin_id) as bin_id from Test_bin; SELECT HEX (bin_id) as bin_id from test_bin WHERE bin_id = Unhex (' fa34e10293cb42848573a4e39937f479 '); SELECT HEX (bin_id) as bin_id from test_bin WHERE bin_id = Unhex (?); SELECT HEX (bin_id) as bin_id from Test_bin WHERE bin_id = x ' fa34e10293cb42848573a4e39937f479 '; query result: Bin_ ID--------------------------fa34e10293cb42848573a4e39937f479

Note: use the MySQL built-in UUID () to create a function that returns a binary (16) type of UUID value

Create function uu_id () RETURNS binary (+) RETURN Unhex (REPLACE (UUID (), '-', ')), or create function uu_id () RETURNS binary ( ) RETURN Unhex (REVERSE (REPLACE (UUID (), '-', ')); use: INSERT into Test_bin (bin_id) VALUES (uu_id ());

Binary type operation for MySQL