MySQL 保存tuple类型_使用Python插入多个MySQL记录。错误：“Python'tuple'无法转换为MySQL类型”...

最新推荐文章于 2024-09-26 15:57:58 发布

ScandalRafflesia

最新推荐文章于 2024-09-26 15:57:58 发布

阅读量978

点赞数

文章标签： MySQL 保存tuple类型

本文链接：https://blog.csdn.net/weixin_26798991/article/details/113981539

版权

使用Python插入多个MySQL记录

错误：Python“tuple”无法转换为MySQL类型

错误代码：

python python_mysql_2.py

回溯(最近一次呼叫)：

文件“C:\Users\POM\AppData\Local\Programs\Python37-32\lib\site packages\mysql\connector\转换.py“，第181行，在tou mysql中

return getattr(self，“{0}u to_mysql”.format(type_name))(value)

AttributeError:“MySQLConverter”对象没有属性“tuple”to“u mysql”During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "C:\Users\POM\AppData\Local\Programs\Python\Python37-32\lib\site-packages\mysql\connector\cursor.py", line 432, in _process_params

res = [to_mysql(i) for i in res]

File "C:\Users\POM\AppData\Local\Programs\Python\Python37-32\lib\site-packages\mysql\connector\cursor.py", line 432, in

res = [to_mysql(i) for i in res]

File "C:\Users\POM\AppData\Local\Programs\Python\Python37-32\lib\site-packages\mysql\connector\conversion.py", line 184, in to_mysql

"MySQL type".format(type_name))

TypeError: Python 'tuple' cannot be converted to a MySQL type

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "python_mysql_2.py", line 22, in

my_cursor.execute(mike_placeholders,records_list)

File "C:\Users\POM\AppData\Local\Programs\Python\Python37-32\lib\site-packages\mysql\connector\cursor.py", line 557, in execute

psub = _ParamSubstitutor(self._process_params(params))

File "C:\Users\POM\AppData\Local\Programs\Python\Python37-32\lib\site-packages\mysql\connector\cursor.py", line 437, in _process_params

"Failed processing format-parameters; %s" % err)

mysql.connector.errors.ProgrammingError: Failed processing format-parameters; Python 'tuple' cannot be converted to a MySQL type

Python代码：

^{pr2}$