Sql

Search

insert ip address in mysql

-- `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
$ipaddress = $_SERVER['REMOTE_ADDR'];  
var_dump(ip2long('123.63.153.253'));	-- 2067765757
var_dump(long2ip(2067765757));			-- "123.63.153.253"

Comment

PREVIOUS	NEXT

Code Example
Sql :: cte in sql server
Sql :: postgres advance auto increment
Sql :: creashed table mysql
Sql :: oracle no data found error code
Sql :: violation of primary key constraint
Sql :: oracle cache matching
Sql :: insert data to postgresql from excel
Sql :: function plsql
Sql :: MySQL error code 2068
Sql :: sqlalchemy orm duplicate
Sql :: snowflake insert select
Sql :: advantages of stored procedures sql
Sql :: what are the data types
Sql :: joint query
Sql :: hyphen error in database mysql
Sql :: how to find 2nd highest salary in mysql
Sql :: select in select sql
Sql :: oracle procedure teamplate
Sql :: auto increment psql not primary key
Sql :: compare if is null sql
Sql :: select sql
Sql :: enable mysql query log
Sql :: SQL SELECT AS Alias
Sql :: insert overwrite table in mysql in nifi
Sql :: in subquery terminology, the first query in the sql statement is known as the _____ query.
Sql :: realtime database push multiple values
Sql :: How to make PHP handeling my "WITH CTE as" SQL
Sql :: search all tables in a database for a value
Sql :: get the previous column of a table in mysql
Sql :: ring MySQL create new table and insert records

Search

SQL

insert ip address in mysql

ADD CONTENT