python读取sql server

最新推荐文章于 2024-07-29 02:36:06 发布

河北一帆

最新推荐文章于 2024-07-29 02:36:06 发布

阅读量832

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/qq_41816368/article/details/108746410

版权

import pymssql


conn = pymssql.connect(host='localhost', user='***', password='***', database='earth_pressure')
cur = conn.cursor()
#ringNumber pressureAverage forwardVelocity conveyorSpeed为列名，earth_pressure_100_250为标名，where后面为筛选条件
sql = 'select ringNumber,pressureAverage,forwardVelocity,conveyorSpeed from earth_pressure_100_250 where ringNumber>='+str(currentRingNumber-20)+' and ringNumber <='+str(currentRingNumber)
dataDf = pd.read_sql(sql, conn)

conn.commit()
cur.close()
conn.close()