Python-da SQL so'rov orqali yozuvlarni yangilash

Keling, endi yozuvlarni o'zgartirishni o'rganaylik. Buning uchun UPDATE buyrug'i ishlatiladi. Uning sintaksisi quyidagicha:

pythonquery = "UPDATE jadval SET maydon = qiymat WHERE shart"
with connection.cursor(dictionary=True) as cursor:
  cursor.execute(query)
  connection.commit()

UPDATE buyrug'i bilan commit metodini majburiy qo'llash kerak:

pythonwith connection.cursor(dictionary=True) as cursor:
  cursor.execute(query)
  connection.commit()

Misol

Keling, foydalanuvchining yoshini va maoshini o'zgartirib ko'ramiz:

pythonquery = "UPDATE users SET age=20, salary=800 WHERE id=1"

Misol

23 yoshdagi barcha foydalanuvchilarga 400 maosh va 24 yosh belgilaymiz:

pythonquery = "UPDATE users SET age=24, salary=300 WHERE age=23"

Amaliy vazifalar