#%%import pymssql as MySQLdb #這里是python3 如果你是python2.x的話，import MySQLdb#數(shù)據(jù)庫連接屬性hst = '188.10.34.18'usr = 'sa'passwd = 'p@ssw0rd'db = 'HistoryTrace' #總共多少數(shù)據(jù)allData = 1674333#每個批次多少條數(shù)據(jù)dataOfEach = 20000#批次batch = ceil(allData/dataOfEach) #文件名global IDctrl IDctrl = 1filename = str(IDctrl)+'.txt' #連接數(shù)據(jù)庫conn = MySQLdb.connect(host=hst,user=usr,password=passwd,database=db)cur=conn.cursor() while IDctrl<batch: #讀取數(shù)據(jù)庫 sql = 'SELECT Longitude,Latitude,Altitude,VelComOfLong,VelComOfLati,Aircraft,Section,TimeMinus/    FROM dealed1 where ID>=' + str(IDctrl) + ' and ID <' + str(IDctrl + dataOfEach)  cur.execute(sql) rows=cur.fetchall() #寫文件 f = open(filename,'w') f.writelines(str(rows)) #文件名加1 IDctrl+=1 filename = str(IDctrl)+'.txt' #關閉數(shù)據(jù)庫連接f.close()conn.close()