通过mysql将ip和unix放到一个字段，并还原

将ip和unix合并为一个字符串

select concat(conv(inet_aton(ip),10,32),'_',conv(unix,10,32))ip_unix from (select UNIX_TIMESTAMP()as'unix','255.255.255.255'as'ip')t

ip_unix
3VVVVVV_1GQLT0A

将字符串还原为ip和unix

select inet_ntoa(conv(SUBSTRING_INDEX(ip_unix,'_',1),32,10))'ip',conv(SUBSTRING_INDEX(ip_unix,'_',-1),32,10)'unix' from (select '3VVVVVV_1GQLT0A'as'ip_unix')t

ip	unix
255.255.255.255	1638593546