您可以傳遞:id + null,它將為id列的:id + null求值為null,它將獲得適當的值,因為它被定義為INTEGER PRIMARY KEY: sql = "INSERT INTO albums VALUES (:id + null, :nr, :band, :song, :album, :duration)"main_cursor = db_main.cursor()for row in output: main_cursor.execute(sql, row) 或者,使用executemany()來避免for循環: sql = "INSERT INTO albums VALUES (:id + null, :nr, :band, :song, :album, :duration)"main_cursor = db_main.cursor()main_cursor.executemany(sql, output)