Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql存储ip_MySQL

mysql存储ip_MySQL

WBOY
Release： 2016-06-01 13:43:54
Original
837 people have browsed it

bitsCN.com 把ip地址存成unsigned int
 
在mysql中
 
查询的时候把一个ip使用INET_ATON()把ip转换成整形，使用INET_NOTA()把整形转换成字符串ip
 
在php中也有这样的函数分别是，ip2long() 和long2ip()
 
数据量很大的话，会检索很快的 bitsCN.com

Related labels：
IP address string
source：php.cn
Previous article：从MYSQL到oracle的迁移以及备份_MySQL Next article：学习mysql的一些记录_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Using Eloquent for internal querying The image address contains the location and total number of users. Users::with(['address'=...
From 2024-04-06 16:45:50
0
1
515
I want to send two different emails to two different addresses using php in the same function So when a product is ordered from a merchant registered on my website, I want my code to u...
From 2024-04-04 22:17:09
0
1
1481
Problem: Problem when using rewrite rules to redirect a folder to a PHP file with the same name Directly have the root directory as shown below, as you can see I have a folder and file w...
From 2024-04-04 12:33:52
0
1
429
What is the difference between HTML tags <a></a> and <a href=""></a>? Some websites use [url]website address[/url] in their text area and cannot add anchor text...
From 2024-04-02 22:46:16
0
2
403
Unable to establish external connection to MySQL/MariaDB database I'm trying to connect a MariaDB client (DBeaver) to my database from my home computer. The...
From 2024-03-31 23:39:43
0
1
302
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template