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 vote320 views1 answer
Oracle query archivemode
SQL
4 votes302 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote303 views1 answer
Add sqlite3 in lumen
SQL
1 vote293 views1 answer
How to delete record sql delphi
SQL
0 vote309 views1 answer
A network or instance-specific error sql server
SQL
0 vote320 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote341 views1 answer
Oracle grant create job
SQL
0 vote341 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
18 votes267 views2 answers
How to get all the tables displayed in oracle
SQL
31 votes310 views1 answer
Postgresql add column with constraint
SQL