mysql实现：随机生成一批ipv4、ipv6地址

-- 生成ipv6

update log set ipv6=
(
SELECT
    CONCAT(
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0'),
        ':',
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0'),
        ':',
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0'),
        ':',
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0'),
        ':',
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0'),
        ':',
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0'),
        ':',
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0'),
        ':',
        LPAD(HEX(FLOOR(RAND() * 65536)), 4, '0')
    ) AS random_ipv6
FROM
    (SELECT 1) AS numbers
)

where ipv6 is null or ipv6=''








-- 生成ipv4

update log set ipv4=
(
SELECT CONCAT(
    FLOOR(RAND() * 256), '.', 
    FLOOR(RAND() * 256), '.', 
    FLOOR(RAND() * 256), '.', 
    FLOOR(RAND() * 256)
) AS random_ipv4
FROM (SELECT 1 ) AS numbers
)

where ipv4 is null or ipv4=''