<p>我有一个问题,为什么我会犯这个错误。
我尝试将python脚本中的一些数据插入mysql</p>
<p>这是我的代码:</p>
<pre><code>queryinsertStatus = "INSERT INTO general (status) VALUES (%s, )"
onlinestatus = (y["msg"])
print(onlinestatus)
cursor.execute(queryinsertStatus, onlinestatus)
</code></pre>
<p>但结果我得到了:</p>
<pre><code>API online
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 204, in execute
query = query % args
TypeError: not all arguments converted during bytes formatting
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "trading.py", line 30, in <module>
cursor.execute(queryinsertStatus, onlinestatus)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 206, in execute
raise ProgrammingError(str(m))
MySQLdb._exceptions.ProgrammingError: not all arguments converted during bytes formatting
</code></pre>
<p>我错了什么?onlinestatus包含一个“API online”</p>
<p>mySQL属于tinytext类型</p>
<p>希望有人能帮助我</p>