mysql生成uuid连续_MySQL为多行生成UUID()

来自@TimBiegelsen的

link解决方案正常运行.

我声明了一个根据v4标准生成UUID的函数.

CREATE FUNCTION uuid_v4()

RETURNS BINARY(16)

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 UNHEX(LOWER(CONCAT(@h1, @h2, @h3, @h4, @h5, @h6, @h7, @h8)));

END;;

DELIMITER ;