mysql 存放IP地址的简单办法 / 时间戳

IP地址转为int整数存放在表中

MYSQL IP地址转为int整数函数 INET_ATON('IP地址')
mysql> SELECT INET_ATON('209.207.224.40');
+-----------------------------+
| INET_ATON('209.207.224.40') |
+-----------------------------+
|                  3520061480 |
+-----------------------------+
1 row in set (0.00 sec)

MYSQL int整数转为IP地址 INET_NTOA(整数)
mysql>  SELECT INET_NTOA(3520061480);
+-----------------------+
| INET_NTOA(3520061480) |
+-----------------------+
| 209.207.224.40        |
+-----------------------+
1 row in set (0.00 sec)

时间戳:将时间以整数方式保存

第一个将时间存为整数

第二个将整数转为时间

mysql> select unix_timestamp(now());
+-----------------------+
| unix_timestamp() |
+-----------------------+
|            1525247173 |
+-----------------------+
1 row in set (0.00 sec)

mysql> select from_unixtime(1525247173,'%Y-%m-%d %H:%i:%s');
+-----------------------------------------------+
| from_unixtime(1525247173,'%Y-%m-%d %H:%i:%s') |
+-----------------------------------------------+
| 2018-05-02 15:46:13                           |
+-----------------------------------------------+
1 row in set (0.00 sec)