sqlite3.ERROR:输入不完整

Question

这就是我一直得到的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))

Answer 1

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

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

另外，您发布的代码片段还有一个语法错误："part50)"和(part1之间应该有一个逗号。你知道吗