mysql输出uuid_如何在MySQL中生成UUIDv4？

我花了很长时间寻找解决方案并提出以下建议

使用标准MySQL生成随机UUID(即UUIDv4)的mysql函数

职能.我正在回答我自己的问题,希望能分享这个问题

有用.

-- Change delimiter so that the function body doesn't end the function declaration

DELIMITER //

CREATE FUNCTION uuid_v4()

RETURNS CHAR(36)

BEGIN

-- Generate 8 2-byte strings that we will combine into a UUIDv4

SET @h1 = LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, '0');

SET @h2 = LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, '0');

SET @h3 = LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, '0');

SET @h6 = LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, '0');

SET @h7 = LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, '0');

SET @h8 = LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, '0');

-- 4th section will start with a 4 indicating the version

SET @h4 = CONCAT('4', LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, '0'));

-- 5th section first half-byte can only be 8, 9 A or B

SET @h5 = CONCAT(HEX(FLOOR(RAND() * 4 + 8)),

LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, '0'));

-- Build the complete UUID

RETURN LOWER(CONCAT(

@h1, @h2, '-', @h3, '-', @h4, '-', @h5, '-', @h6, @h7, @h8

));

END

//

-- Switch back the delimiter

DELIMITER ;

注意：使用的伪随机数生成(MySQL的RAND)不是

加密安全,因此有一些偏差,可以增加碰撞

风险.