import pymssql
# 连接数据库服务器
getConn = pymssql.connect('192.168.0.6','admin','123456','ylwcc_db')
# 获取游标
getCursor=getConn.cursor()
# 执行SQL语句
getCursor.execute("select * from T_YY_MAINTENANCERECORD where repairOrder='1542347553075'")
result = getCursor.fetchone()
# 去掉,
results = (','.join(result))
print(results)
Python连接数据库
importpymssql# 连接数据库服务器getConn = pymssql.connect('192.168.0.6','admin','123456','ylwcc_db')# 获取游标getCursor=getConn.cursor()# 执行SQL语句getCursor.execute("select *from T_YY_MAINTENANCERECORD wherere...
·
转载于:https://www.cnblogs.com/fanqian0330/p/10368159.html
更多推荐



所有评论(0)