python - SQL 查询正在创建一个空列表

Question

try:
    conn = sql.connect(file)
    cursor = conn.cursor()
    print("Connected to Database.")
except:
    print ("Connection failed.")

try:  
    sql_query = "SELECT * FROM strains WHERE Shelf = (?) and 'Strain Type' = (?)"
    args = (shelfplacement, straintype,)
    cursor.execute(sql_query,args) 
    simstrains = cursor.fetchall()
    print("Similar Strains:")
    for row in simstrains:
        print("Strain Type: ", row[0])
        print("Percentage Mix: ", row[1])
        print("Strain: ", row[3])
        print("Shelf: ", row[4])
        print("THC Percent: ", row[9])
        print("\n")
        
    cursor.close()
    
except sql.Error as error:
    print(error)
    
finally:
    if conn:
        conn.close()
        print('The SQL connection is closed')
         
getstraininfo()

    

此代码未simstrains使用填充列表填充变量。我的查询语句不正确吗？我将不胜感激任何帮助！

标签： pythonsqldatabasesqlite

Answer 1

尝试用 [应变类型] 替换“应变类型”。带空格的列名需要用 [] 或 " " 包围