Python MySQL Delete From

Fungua rekodi

Wingiwe inaingia 'DELETE FROM' kufungua rekodi kutoka tablica zilizojengwa

Mfano

Fungua rekodi zote ambazo zinaadili 'Mountain 21'

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DELETE FROM customers WHERE address = 'Mountain 21'
mycursor.execute(sql)
mydb.commit()
print(mycursor.rowcount, "kifaa kidhibitiweza kufungua")

Runia Mfano

Muhimu:Tafuta maana ya hili kigeukio mydb.commit()Inafaa kumaliza, inaingia kama inaingia tablica inaingia kinaendelea kwa kila mashabiki

Tafuta maana ya WHERE katika kiingilio cha DELETE: kigeukia kwa WHERE inaonyesha rekodi ambazo lazima zitofungwe. Ikiwa WHERE haitakuwa na maana, zote rekodi zizatofungwa!

Kusikia kwa SQL Injection

Kuwalipisha thamani yoyote ya kila kusikia kwenye kifungo cha kufungua kwa thamani ni tabia mpya kwa kumtangaza.

Hii inafikia kusaidia kusikia kwa SQL Injection, ambayo inaonekana kama teknolojia ya mtu wa mtukio, inaweza kumtegemea na kusababisha usababishaji au kusababisha matumizi ya mbali ya vyombo vya data yako.

Moduli ya mysql.connector inatumia kifunguo kwa thamani ％s Kuwalipisha thamani kwenye kifungo cha kufungua kwa thamani:

Mfano

Tumia kifunguo kwa thamani: ％s Mwendo wa kuwalipisha thamani:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DELETE FROM customers WHERE address =" %s"
adr = ("Yellow Garden 2", )
mycursor.execute(sql, adr)
mydb.commit()
print(mycursor.rowcount, "kifaa kidhibitiweza kufungua")

Runia Mfano