HDC调试需求开发（15万预算）,能者速来！>>>
运用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 Server\n")