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

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]