mysql 常用sql

INET_ATON(‘127.0.0.1‘)   ip字符串转数字
INET_NTOA(xx)    数字转ip字符串

UNIX_TIMESTAMP()   以unix时间戳返回当前时间
FROM_UNIXTIME(xx) 将unix时间戳转换为普通格式时间

CREATE TABLE table_fun (
    id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    ip INT(10) UNSIGNED NOT NULL DEFAULT 0,
    addtime INT(10) UNSIGNED NOT NULL DEFAULT 0
    );

insert into table_fun(ip,addtime) values(inet_aton(‘192.168.1.1‘),unix_timestamp());

select inet_ntoa(ip),from_unixtime(addtime) from table_fun;

delete from table_fun where inet_ntoa(ip)=‘192.168.1.0‘;