mysql inet_aton和inet_ntoa存储ip地址

添加ip字段

 alter table student add ip int unsigned not null after sex;

添加记录

insert into student(name,sex,ip) value('张涛','男',inet_aton('192.168.2.65'));

查询

 select inet_ntoa(ip) as ip from student;