1、创建表
create table dm_ip_class
( ipstart varchar2(50),
ipend varchar2(50),
country varchar2(50),
isp varchar2(100),
province varchar2(100),
city varchar2(100),
county varchar2(100),
country_confidence varchar2(50),
isp_confidence varchar2(50),
province_confidence varchar2(50),
city_confidence varchar2(50),
county_confidence varchar2(50));
comment on table dm_ip_class
is 'IP码表';
comment on column dm_ip_class.ipstart
is '起始IP地址';
comment on column dm_ip_class.ipend
is '结束IP地址';
comment on column dm_ip_class.country
is '国家';
comment on column dm_ip_class.isp
is '运营商';
comment on column dm_ip_class.pro