Mysql 根据子网掩码计算 IP地址范围 IP最大值最小值

 

 

 

select inet_aton("192.168.1.1");
select bin(inet_aton("192.168.1.1"));



select bin(inet_aton("192.168.1.1")|inet_aton("255.255.254.0"));
select bin(inet_aton("192.168.1.1")&inet_aton("255.255.254.0")),bin(inet_aton("192.168.1.1")&inet_aton("255.255.254.0"));

select bin(inet_aton("255.255.254.0")),bin(inet_aton("255.255.248.0"));
select inet_ntoa(inet_aton("192.168.8.1")&inet_aton("255.255.248.0"));
select bin(inet_aton("255.255.248.0")),bin(inet_aton("255.255.248.0"));


select inet_aton("255.255.255.255")-inet_aton("255.255.248.0"),bin(inet_aton("255.255.255.255")-inet_aton("255.255.248.0"));
select inet_ntoa(inet_aton("192.168.0.1")&inet_aton("255.255.248.0")),
    bin((inet_aton("192.168.0.1")&inet_aton("255.255.248.0"))+(inet_aton("255.255.255.255")-inet_aton("255.255.248.0"))),
    inet_ntoa((inet_aton("192.168.0.1")&inet_aton("255.255.248.0"))+(inet_aton("255.255.255.255")-inet_aton("255.255.248.0")));