import pymssql import pandas as pd conn=pymssql.connect(host='192.168.31.89', user='sa', password='1314ABCDqq', database='bs', charset='utf8') cursor=conn.cursor() sql="SELECT [UNIT_ID],[SPEED],[GPSTIME] FROM [bs].[dbo].[fudongche0309]" df=pd.read_sql(sql,con=conn) print(df.head(6)) df.to_csv('D:/sc1.csv') conn.close()