Mysql中存储UUID去除横线的方法

CREATE FUNCTION `UUIDTOBIN`() RETURNS binary(16)  
BEGIN
DECLARE my_uuid char(36);  
SET my_uuid = UUID();  
RETURN CONCAT(UNHEX(LEFT(my_uuid,8)),UNHEX(MID(my_uuid,10,4)),UNHEX(MID(my_uuid,15,4)),UNHEX(MID(my_uuid,20,4)),UNHEX(RIGHT(my_uuid,12)));  
END
CREATE FUNCTION `BINTOUUID`(UUID BINARY(16)) RETURNS char(36)  
BEGIN
RETURN CONCAT(HEX(LEFT(uuid,4)),'-', HEX(MID(uuid,5,2)),'-', HEX(MID(uuid,7,2)),'-',HEX(MID(uuid,9,2)),'-',HEX(RIGHT(uuid,6)));  
END

您可能感兴趣的文章:

mysql中如何去除小数点后面多余的0解析mysql中:单表distinct、多表group by查询去除重复记录mysql SELECT语句去除某个字段的重复信息MySQL 去除重复数据实例详解