query="select task_type from task_type_table where module_name=%(MODULE_NAME)s and task_name=%(TASK_NAME_img)s" % vars() cursor_fetch.execute(query) results=cursor_fetch.fetchall() MODULE_NAME和TASK_NAME_img都是变量的名字
PIPIONE
浏览 99回答 2
2回答
湖上湖
query="select task_type from task_type_table where module_name=%s and task_name=%s"cursor_fetch.execute(query, [var1, var2])results=cursor_fetch.fetchall()我这样的sql查询是没问题的你的出错可能是字符串缺少引号的缘故吧
query="select task_type from task_type_table where module_name=%(MODULE_NAME)s and task_name=%(TASK_NAME_img)s"cursor_fetch.execute(query, vars())results=cursor_fetch.fetchall()