python mysql插入語句 返回1064
問題描述
Traceback (most recent call last): File 'python_mysql.py', line 78, in <module>
x.cb_model_add()
File 'python_mysql.py', line 17, in cb_model_add
self.cursor.executemany(sql, params)
File 'build/bdist.linux-x86_64/egg/MySQLdb/cursors.py', line 262, in executemany File 'build/bdist.linux-x86_64/egg/MySQLdb/cursors.py', line 354, in _query File 'build/bdist.linux-x86_64/egg/MySQLdb/cursors.py', line 318, in _do_query_mysql_exceptions.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’:code)’ at line 2')
sql語句如下:sql='insert into test1 (code) values (:code)'
params = [{’code’:’xx’}] self.cursor.executemany(sql, params)
問題解答
回答1:sql='insert into test1 (code) values (%s)'self.cursor.executemany(sql, code)
相關文章:
1. docker - 如何修改運行中容器的配置2. docker 下面創建的IMAGE 他們的 ID 一樣?這個是怎么回事????3. angular.js使用$resource服務把數據存入mongodb的問題。4. macos - mac下docker如何設置代理5. docker api 開發的端口怎么獲取?6. debian - docker依賴的aufs-tools源碼哪里可以找到啊?7. dockerfile - 我用docker build的時候出現下邊問題 麻煩幫我看一下8. docker網絡端口映射,沒有方便點的操作方法么?9. docker start -a dockername 老是卡住,什么情況?10. docker鏡像push報錯

網公網安備