[mysql] Python - MySQL Delete From (데이터 삭제)

목차

1. DELETE FROM - 데이터 삭제
2. SQL Injection 방지 - %s 자리표시자

DELETE FROM - 데이터 삭제

WHERE 절을 이용해 삭제할 데이터를 선택.

주의:  WHERE 절을 생략하면 모든 데이터가 삭제됨.

 

---

[예제]

 

import mysql.connector

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  password="autoset",

  database="hz"

)

mycursor = mydb.cursor()

sql = "DELETE FROM hz_member WHERE mb_level = '1'"

mycursor.execute(sql)

mydb.commit()

print(mycursor.rowcount, "record(s) deleted")

 

결과값: 1 record(s) deleted

주의: mydb.commit() 없으면, 변화가 반영 X

SQL Injection 방지 - %s 자리표시자

※ DELETE FROM 구문도 %s 자리표시자 메서드로 회피 (escape) 권장.

import mysql.connector

mydb = mysql.connector.connect(

  host="localhost",

  user="root",

  password="autoset",

  database="hz"

)

mycursor = mydb.cursor()

sql = "DELETE FROM hz_member WHERE mb_level = %s"

level = ("2", )

mycursor.execute(sql, level)

mydb.commit()

print(mycursor.rowcount, "record(s) deleted")

 

PS.

Node.js DELETE FROM (데이터 삭제)

https://homzzang.com/b/njs-19