SQLize Online / PHPize Online  /  SQLtest Online

DELIMITER $$ CREATE PROCEDURE GenerateRandomIPv6() BEGIN DECLARE ipv6_address VARCHAR(39) DEFAULT ''; -- IPv6 addresses have a maximum length of 39 characters DECLARE hex_group VARCHAR(4); DECLARE i INT DEFAULT 1; WHILE i <= 8 DO SET hex_group = ''; -- Generate four random hexadecimal characters for each group SET hex_group = CONCAT(hex_group, HEX(FLOOR(RAND() * 16))); SET hex_group = CONCAT(hex_group, HEX(FLOOR(RAND() * 16))); SET hex_group = CONCAT(hex_group, HEX(FLOOR(RAND() * 16))); SET hex_group = CONCAT(hex_group, HEX(FLOOR(RAND() * 16))); SET ipv6_address = CONCAT(ipv6_address, hex_group); IF i < 8 THEN SET ipv6_address = CONCAT(ipv6_address, ':'); -- Add colon after each group except the last one END IF; SET i = i + 1; END WHILE; SELECT ipv6_address AS RandomIPv6Address; END$$ DELIMITER ; CALL GenerateRandomIPv6();