Python MySQL Delete From

Gurbi tashi

Za a iya amfani da hanyarar 'DELETE FROM' domin kara kara tashi daga taba da ke da wuri:

Misali

Gurbi duk tashi da address '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, "record(s) deleted")

Gudan Misali

Mai mahimmanci:Kware hanyarar mydb.commit()Yiwa yana da taba shi, kuma haka yana da taba taba kafin tashoshin zai yi wuri.

Kware masu hanyarar da delete tsare: WHERE hanyarar suna nuna cewa zai iya ci gurbi. Idan ana kara WHERE hanyarar, za a iya gurbi duk dukkan tashi!

Kare da SQL Injection

Dacewa duk wuri da ake so daga kai tsaye na delete:

Haka kuma, amma ana amfani da su don kare da SQL Injection, wanda yana da yawa a cikin hacker, wanda zai yi laifi ko fiye da amfani da dakin gida.

Modulu mysql.connector Ayyuka Gida: ％s Ayyuka Layi na Dacewa don Delete:

Misali

Ayyuka Gida: ％s Hanyar Layi na Dacewa:

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, "record(s) deleted")

Gudan Misali