conn1=MySQLdb.connect(host="165.124.222.222",user="root",passwd="Bluekey_22",db="TraceRoute")
cur1 = conn1.cursor()
CREATETABLE = """create table if not exists TraceRoute.router(id int unsigned not null auto_increment,ip varchar(16),
domainname varchar(60),address varchar(120),latitude varchar(12),longitude varchar(12),
asnumber int unsigned,type tinyint,primary key(id),index(id,ip,type))"""
cur1.execute(CREATETABLE)