mysql 存储ip地址

CREATE TABLE devices (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    ip_address VARCHAR(15)
);

CREATE TABLE devices (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    ip_address INT UNSIGNED
);

DELIMITER $$
CREATE FUNCTION ip2int(ip VARCHAR(15)) RETURNS INT UNSIGNED
BEGIN
    DECLARE octet1, octet2, octet3, octet4 INT;
    SET octet1 = SUBSTRING_INDEX(ip, '.', 1);
    SET octet2 = SUBSTRING_INDEX(SUBSTRING_INDEX(ip, '.', -2), '.', 1);
    SET octet3 = SUBSTRING_INDEX(SUBSTRING_INDEX(ip, '.', -3), '.', 1);
    SET octet4 = SUBSTRING_INDEX(ip, '.', -1);
    RETURN (octet1 * 256 * 256 * 256) + (octet2 * 256 * 256) + (octet3 * 256) + octet4;
END$$
DELIMITER ;

DELIMITER $$
CREATE FUNCTION int2ip(ip INT UNSIGNED) RETURNS VARCHAR(15)
BEGIN
    DECLARE octet1, octet2, octet3, octet4 INT;
    SET octet1 = FLOOR(ip / (256 * 256 * 256));
    SET octet2 = FLOOR((ip % (256 * 256 * 256)) / (256 * 256));
    SET octet3 = FLOOR((ip % (256 * 256)) / 256);
    SET octet4 = ip % 256;
    RETURN CONCAT(octet1, '.', octet2, '.', octet3, '.', octet4);
END$$
DELIMITER ;