我有一个问题:
import jaydebeapi,pandas as pd
cursor = conn.cursor()
cursor.execute('''INSERT INTO MD SELECT DISTINCT MD FROM viewshareddim.TMD_VIP
WHERE STN_ID=? AND P_T in ? AND ID in ? AND C_ID = ?''', (MD[0],MD[1],MD[2],MD[3]))
值包括:
MD = [01,(02,05,06),(02,04,05),8]
尝试引用此处提供的解决方案python list,但不知道如何为我的查询实现该解决方案。如果能提供任何指导,我将不胜感激。
我试过了:
INSERT INTO MD SELECT DISTINCT MD FROM viewshareddim.TMD_VIP
WHERE STN_ID=(?) AND P_T in (?) AND ID in (?) AND C_ID = (?), (MD[0],MD[1],MD[2],MD[3])
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-
packages/jaydebeapi/__init__.py", line 499, in execute
self._set_stmt_parms(self._prep, parameters)
File
"/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/jaydebeapi/__init__.py", line 490, in _set_stmt_parms
prep_stmt.setObject(i + 1, parameters[i])
RuntimeError: No matching overloads found for setObject in find. at
native/common/jp_method.cpp:127
发布于 2018-07-26 04:27:42
我尝试让列表得到评估,这样当它被传递到数据库时,它只是一个由DB执行的字符串
https://stackoverflow.com/questions/51526720
复制相似问题