Storing an IP address in a database table

/ Published in: SQL
Save to your folder(s)

You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15).
MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP stack implementation or even application.
The INET_ATON() function converts Internet addresses from the numbers-and-dots notation into a 32-bit unsigned integer, and INET_NTOA() does the opposite.

Copy this code and paste it in your HTML
  1. SELECT INET_ATON('') AS ipn;
  2. SELECT INET_NTOA(3232235530) AS ipa;
  3. INSERT INTO tbl VALUES (..., INET_ATON(''), ...);


Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.