Mysql中把ip地址和int数字互转: SELECT INET_ATON("127.0.0.1") FROM DUAL; SELECT INET_NTOA(1953789044) FROM DUAL;