where python报错_MySQL错误1054:“where子句”中的列未知

我有一个字典列表，在清除数据后，这些字典将作为参数传递给updateResource()。在#method to clean the dictionary data

def getResource(self):

try:

for i in range(len(data)):

sys_name = data[i]["system_name"]

team = data[i]["fdc_inv_sa_team"]

sys_name = re.sub('.1DC.com|.1dc.com|.1dc.COM |.1DC.COM\\b', '', str(sys_name))

sys_name = str(sys_name.strip('"[]"'))

team = str(team).replace('\\n', '')

team = str(str(team).strip("[]"))

data[i]["system_name"] = sys_name

data[i]["fdc_inv_sa_team"] = team

return data

except Exception, e:

logger.error("Error : ", str(e))

下面是一个方法，它将字典列表作为参数，并在执行一些检查后更新数据库。在

^{pr2}$

以下是查询示例-select_query = "SELECT resource_id, resource_name, support_contact_id \

FROM echo_resource \

WHERE resource_name = (%s) \

AND inactive = 0;"

update_query = "UPDATE echo_resource \

SET support_contact_id = ( \

SELECT contact_id FROM contacts WHERE last_name = (%s)), \

update_date = (%s) \

WHERE resource_name = (%s);"

contact_echo_resource_query = "SELECT 1 \

FROM echo_resource \

WHERE resource_name = (%s) \

AND support_contact_id = (SELECT contact_id \

FROM contacts \

WHERE last_name = (%s));"

contacts_query = "SELECT 1 \

FROM contacts \

WHERE last_name = (%s);"

insert_query = "INSERT INTO echo_resource_log VALUES(%s, %s, %s, %s);"

echo_资源表的结构-resource_id varchar(40) NO PRI

resource_name varchar(255) YES MUL

description longtext YES

ip_address varchar(40) YES

resource_tag varchar(40) YES

support_contact_id int(11) YES MUL

last_found_date_time datetime YES

错误消息-[2017-07-17 18:14:31,794] {updateEchoResource.py:82} DEBUG - Arguments for the queries : n3bvap049, X2Linux_NSS

[2017-07-17 18:14:31,795] {updateEchoResource.py:121} ERROR - Error 1054: Unknown column 'n3bvap049' in 'where clause'