Mysql store ip address

-- `ip_address` int(4) unsigned NOT NULL
INSERT INTO my_table (`ip_address`) VALUES (INET_ATON("127.0.0.1"));
SELECT INET_NTOA(ip_address) as ip FROM my_table;
-- php
<?php
var_dump(ip2long('123.63.153.253'));	-- 2067765757
var_dump(long2ip(2067765757));			-- "123.63.153.253"
?>

Source: onlinewebtutorblog.com

Similar codes

0 vote166 views1 answer
Oracle list datafiles
SQL
11 votes173 views1 answer
Ddl view
SQL
5 votes164 views1 answer
Sql use database
SQL
1 vote174 views1 answer
Sql server kill all connections
SQL
0 vote157 views1 answer
Primary key multiple colums
SQL
5 votes155 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote157 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote150 views2 answers
Sql select only first occurrence
SQL
0 vote170 views1 answer
Take sql dump in to file
SQL
0 vote142 views1 answer
Dump only schema
SQL