python更新sql sever数据库

Question

运用python批量更新sql sever数据库代码如下：

import pymssql
conn = pymssql.connect('WIN-HNJVLQK', 'sa', '123456', 'test3')
cursor = conn.cursor()

b = [(0.6339473553468321, 43628.0),
 (0.6128462794465829, 43604.0),
 (0.4889203748589221, 43600.0),
 (0.4162643710139807, 43602.0),
 (0.4098517090899294, 43658.0),
 (0.36492885266125263, 43595.0),
]
j=0
while j<len(b):
    rank_new = b[j][0]
    RSSID_new = b[j][1]
    #print(rank_new)
    #print(RSSID_new)
    sql_update = 'UPDATE test SET rank = rank_new WHERE RSSID = RSSID_new'
    cursor.execute(sql_update)
    conn.commit()
    j+=1

出错信息：ProgrammingError: (207, b"Invalid column name 'RSSID_new'.DB-Lib error message 20018, severity 16:nGeneral SQL Server error: Check messages from the SQL Servern")

Answer 1

rank_new

注意变量 

Answer 2

谢谢，好人一生平安