主页 / 问题 / 1027524
Accepted
Raharasomaha
Asked:2020-09-24 17:49:54 +0000 UTC2020-09-24 17:49:54 +0000 UTC

如何解决格式字符串错误的参数不足？[关闭]

  • 772

我正在尝试将数据插入数据库。

sql = "insert into items (`resource_id`,`item_link`,`item_title`,`item_datetime`,`item_text_content`) values (%s,%s,%s,%s,%s)"
         cursor.execute(sql, (str(resource_id), str(item_link), str(item_title), str(item_datetime), str(item_content)))

出现此错误：

  Traceback (most recent call last):
  File "C:/PycharmProjects/parser_goose_and_boilerpipe.py", line 83, in <module>
    call_all_func(resources)
  File "C:/PycharmProjects/parser_goose_and_boilerpipe.py", line 79, in call_all_func
    cursor.execute(sql, (str(resource_id), (str(item_link), str(item_title), str(item_datetime), str(item_content))))
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\cursors.py", line 168, in execute
    query = self.mogrify(query, args)
  File "AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\cursors.py", line 147, in mogrify
    query = query % self._escape_args(args, conn)
TypeError: not enough arguments for format string

Process finished with exit code 1

后来我更正了代码从而改变了values

sql = "insert into items (`resource_id`,`item_link`,`item_title`,`item_datetime`,`item_text_content`) values (%s,%s)"
                   cursor.execute(sql, (str(resource_id), str(item_link), str(item_title), str(item_datetime), str(item_content)))

现在错误是：

Traceback (most recent call last):
  File "C:PycharmProjects/parser_russian_resource/parser_goose_and_boilerpipe.py", line 83, in <module>
    call_all_func(resources)
  File "C:PycharmProjects/parser_russian_resource/parser_goose_and_boilerpipe.py", line 79, in call_all_func
    cursor.execute(sql, (str(resource_id), (str(item_link), str(item_title), str(item_datetime), str(item_content))))
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\cursors.py", line 170, in execute
    result = self._query(query)
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\cursors.py", line 328, in _query
    conn.query(q)
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 517, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 732, in _read_query_result
    result.read()
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 1075, in read
    first_packet = self.connection._read_packet()
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\connections.py", line 684, in _read_packet
    packet.check_error()
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "C:AppData\Local\Programs\Python\Python37-32\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.InternalError: (1136, "Column count doesn't match value count at row 1")

Process finished with exit code 1

这个错误已经告诉我列数与行中的值不匹配。由于我values只有两个%s %s 值，是否可能出现此错误？传入values超过2个值再次出现同样的错误TypeError: not enough arguments for format string

python

1 个回答

  1. Best Answer

    试试这样：

    cursor.execute('''INSERT INTO items (resource_id, item_link, item_title, item_datetime, item_text_content)
                   VALUES (%s, %s, %s, %s, %s)''', 
                   ( str(resource_id),
                     str(item_link),
                     str(item_title),
                     str(item_datetime),
                     str(item_text_content)
                   )
               )
    • 2

相关问题