Python和mySQLdb错误:OperationalError:(1054,"where子句'中的未知列")

# 错误示例
SELECT * FROM my_table WHERE unknown_column = 'value';

# 正确示例
SELECT * FROM my_table WHERE existing_column = 'value';

import MySQLdb

try:
    # 连接到MySQL数据库
    conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database')
    
    # 创建游标对象
    cursor = conn.cursor()
    
    # 执行查询语句
    cursor.execute("SELECT * FROM my_table WHERE unknown_column = 'value'")
    
    # 获取查询结果
    results = cursor.fetchall()
    
    # 处理查询结果
    for row in results:
        # 处理每一行数据
        
    # 关闭游标和数据库连接
    cursor.close()
    conn.close()
    
except MySQLdb.Error as e:
    # 处理数据库错误
    print("MySQL Error {}: {}".format(e.args[0], e.args[1]))