Discuss / Python / sql查询时排序,输出时整理列表

sql查询时排序,输出时整理列表

Topic source

Geek_韧

#1 Created at ... [Delete] [Delete and Lock User]
def get_score_in(low, high):    # 返回指定分数区间的名字,按分数从低到高排序    # 查询语句    conn1 = sqlite3.connect(db_file)    cursor1 = conn1.cursor()    cursor1.execute('select * from user FORCE where score BETWEEN ? AND ? order by score ', (low, high))    value = cursor1.fetchall()    # print(value)    values = []    for i in value:        values.append(i[1])    # print(value[0][1])    cursor1.close()    conn1.close()    return values

  • 1

Reply