Most efficient way to store IP Address in MySQL [duplicate]

by

For IPv4 addresses, you may want to store them as an int unsigned and use the INET_ATON() and INET_NTOA() functions to return the IP address from its numeric value, and vice versa.

Example:

SELECT INET_ATON('127.0.0.1');

+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
|             2130706433 | 
+------------------------+
1 row in set (0.00 sec)


SELECT INET_NTOA('2130706433');

+-------------------------+
| INET_NTOA('2130706433') |
+-------------------------+
| 127.0.0.1               | 
+-------------------------+
1 row in set (0.02 sec)

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. How to create a MySQL hierarchical recursive query?
  3. MYSQL OR vs IN performance
  4. SELECTING with multiple WHERE conditions on same column
  5. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. How to find gaps in sequential numbering in mysql?
  8. MySQL: Invalid use of group function
  9. Combining UNION and LIMIT operations in MySQL query
  10. MySQL: View with Subquery in the FROM Clause Limitation
  11. MySQL comparison with null value
  12. Matching all values in IN clause
  13. MySql export schema without data
  14. INTERSECT in MySQL
  15. How do I get the ID of multiple inserted rows in MySQL?
  16. How to alter a column and change the default value?
  17. limiting the rows to where the sum a column equals a certain value in MySQL
  18. MySql Transpose Row into Column and Column into Row [duplicate]
  19. How to select column names dynamically in mySQL
  20. sql join tables where 1 column has comma
  21. Remove special characters from a database field
  22. Why the order of evaluation for expressions involving user variables is undefined?
  23. sql like operator on integer
  24. How to select data where a field has a min value in MySQL?
  25. MySQL – SELECT * INTO OUTFILE LOCAL ?
  26. How to SELECT by MAX(date)?
  27. The best way to remove value from SET field?
  28. get a recursive parent list
  29. MySQL: Computed Column
  30. mySQL query to search all tables within a database for a string?

Leave a Comment