私有ip地址子网掩码
10.0.0.0 - 10.255.255.255255.0.0.0
172.16.0.0 - 172.31.255.255255.255.0.0
192.168.0.0 - 192.168.0.255255.255.255.0
常用网段掩码
192.168.1.0255.255.255.0

常用网关:192.168.1.1 或 192.168.1.254

特殊IP地址用途
0.0.0.0任意地址
255.255.255.255有限广播地址
127.0.0.1环回地址
169.254.X.XAPIPA地址(本地链路地址)
1.2.4.8CNNIC SDNS
8.8.8.8谷歌DNS地址
223.5.5.5阿里云公共DNS
223.6.6.6阿里云公共DNS
114.114.114.114114公共DNS
119.29.29.29腾讯公共DNS
180.76.76.76百度公共DNS

select concat('update ck_auth_rule set weigh = ',rn,' where id = ',id,';') as sql_text
  from (select id,pid,
               100 - row_number() over(partition by pid order by id) as rn
          from ck_auth_rule ) t ;