Pythonda SQL so'rov orqali yozuvlarni o'chirish
DELETE buyrug'i yordamida
jadvaldan yozuvlarni o'chirish mumkin.
Uning sintaksisi siz ilgari o'rganganiga o'xshaydi:
query = "DELETE FROM jadval WHERE shart"
DELETE buyrug'i bilan albatta
commit metodini qo'llashingiz kerak:
with connection.cursor(dictionary=True) as cursor:
cursor.execute(query)
connection.commit()
id si 7 ga teng bo'lgan foydalanuvchini o'chiring.
Yoshi 23 da bo'lgan barcha foydalanuvchilarni o'chiring.
id si 5 dan katta va maoshi 900 dan katta yoki teng bo'lgan barcha foydalanuvchilarni o'chiring.
Barcha foydalanuvchilarni o'chiring.
