时间戳

首页 > 解决方案 > sqlite3.OperationalError：输入不完整

python - sqlite3.OperationalError：输入不完整

问题描述

这是我不断收到的INSERT INTO命令错误。

Traceback (most recent call last):
  File "C:/Users/cabca/.PyCharmCE2019.2/config/scratches/test.py", line 34, in <module>
    part43, part44, part45, part46, part47, part48, part49, part50))
TypeError: 'str' object is not callable

该代码试图在后半部分调用一个字符串，但这是不可能的。我知道我不能删除 ()，因为它给它的方式超过了它可以接受的最大值 2。

c.execute("INSERT INTO _part_table_ (part1, part2, part3, part4, part5, part6, part7, part8, part9, part10,"
        "part11, part12, part13, part14, part15, part16, part17, part18, part19, part20, part21, part22, part23,"
        "part24, part25, part26, part27, part28, part29, part30, part31, part32, part33, part34, part35, part36,"
        "part37, part38, part39, part40, part41, part42, part43, part44, part45, part46, part47,part48, part49,"
        "part50)" (part1, part2, part3, part4, part5, part6, part7, part8, part9, part10, part11, part12, part13, part14,
        part15, part16, part17, part18, part19, part20, part21, part22, part23, part24, part25, part26, part27, part28,
        part29, part30, part31, part32, part33, part34, part35, part36, part37, part38, part39, part40, part41, part42,
        part43, part44, part45, part46, part47, part48, part49, part50))

标签： pythonsqlite

解决方案

你的INSERT陈述是错误的。您要查找的表格是INSERT INTO <table_name> (column1, column2, ...) VALUES(?, ?, ...). 例如：

cursor.execute(
    '''
    INSERT INTO _part_table_ (
      part1,
      part2,
      part3
    ) VALUES (?,?,?)
    ''', 
    (part1, part2, part3))

PS您发布的代码段也有语法错误："part50)"和之间应该有一个逗号(part1。

推荐阅读