添加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;
添加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;