带符号的列表必须是整数或切片，而不是元组

Question

我想做的是只将6行导入2D列表，这是我代码的一部分：

cur = connection.cursor()

sql_select_query = """select * from image"""

cur.execute(sql_select_query)

record = cur.fetchall()

imgs_recently = [["","",""],["","",""],["","",""],["","",""],["","",""],["","",""]]

  

for row in record:

    imgs_recently[row][0] = row[0] # img id

    imgs_recently[row][1] = row[2] # location

    imgs_recently[row][2] = row[5] # img path

我假装我的错误是我把行作为数组和索引？如果是这样，我该如何解决此错误？

Answer 1

imgs_recently = [ [ row[0], row[2], row[5] ] for row in record[:6] ]就是这样。

Answer 2

你使用作为列表索引，这就是为什么它抛出这种错误。所以在你的情况下是一个元组，你必须使用整数或切片。所以你可以尝试rowrowrow[n]