Converting an IP to a Long（or long to ip） in MySQL

1.ip to long ，eg：127.0.0.1 to long

SELECT INET_ATON('127.0.0.1');

result:2130706433

2.long to ip,  eg：2130706433 to ip

SELECT INET_NTOA('2130706433');

result:127.0.0.1