python 使用内连接更新mysql

Question

这个查询在PyMysql中不起作用，我似乎找不到问题。

query = """UPDATE user INNER JOIN identification_card ON user.id = %s SET user.id_type = %s, user.validity = %s"""
data = (identification_card.user_id, identification_card.card_type, identification_card.expiry_date)
cursor.execute(query,data)

Answer 1

为什么要传递列名称而不是值

或者您只需使用连接的列名称作为值

  UPDATE user 
  INNER JOIN identification_card ON user.id = identification_card.user_id 
  SET user.id_type = identification_card.card_type 
  user.validity = identification_card.expiry_date 




query = """UPDATE user 
  INNER JOIN identification_card ON user.id = identification_card.user_id 
  SET user.id_type = identification_card.card_type 
  user.validity = identification_card.expiry_date"""

cursor.execute(query,data)