---
title: Python MySQL Delete From By
description: "## Delete Record – Мөр Устгах You can delete records from an existing table by using the “DELETE FROM” statement: Одоо байгаа хүснэгтээс мөр устгахын тулд “DELETE FROM” мэдэгдлийг ашиглана: ##### Example – Жишээ Delete any record where the address…"
url: "https://apprentice.mn/docs/python-mysql-delete-from-by/"
updated: "2024-08-05"
category: Python
---

# Python MySQL Delete From By

## Delete Record – Мөр Устгах

You can delete records from an existing table by using the “DELETE FROM” statement:

Одоо байгаа хүснэгтээс мөр устгахын тулд “DELETE FROM” мэдэгдлийг ашиглана:

##### Example – Жишээ

Delete any record where the address is “Mountain 21”:

Хаяганд нь “Mountain 21” орсон мөрүүдийг устгах:

`import mysql.connectormydb = mysql.connector.connect(  host="localhost",  user="yourusername",  password="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")`

**Important!:** Notice the statement: `mydb.commit()`. It is required to make the changes, otherwise no changes are made to the table.

**Анхаарах чухал зүйл!:** `mydb.commit()` мэдэгдлийг анхаарна уу. Өөрчлөлтүүдийг хийхийн тулд энэ шаардлагатай, эс тэгвээс хүснэгт ямар ч өөрчлөлт хийхгүй.

**Notice the WHERE clause in the DELETE syntax:** The WHERE clause specifies which record(s) that should be deleted. If you omit the WHERE clause, all records will be deleted!

**DELETE синтакс дахь `WHERE` нөхцөлийг анхаарна уу:** `WHERE` нөхцөл нь ямар мөр(үүд)-ийг устгахыг тодорхойлдог. Хэрэв та `WHERE` нөхцөлийг орхивол бүх мөрийг устгагдах болно!

## Prevent SQL Injection – SQL халдлагаас урьдчилан сэргийлэх

It is considered a good practice to escape the values of any query, also in delete statements.

Ямар ч хүсэлтийн утгыг алдахгүй байх нь сайн практик гэж тооцогддог бөгөөд энэ нь устгах мэдэгдэлд мөн хамаарна.

This is to prevent SQL injections, which is a common web hacking technique to destroy or misuse your database.

Энэ нь таны өгөгдлийн санг эвдэх эсвэл буруу ашиглахад, түгээмэл хэрэглэгддэг вэб хакердах техник болох SQL халдлагаас урьдчилан сэргийлэх зорилготой.

The mysql.connector module uses the placeholder `%s` to escape values in the delete statement:

`mysql.connector` модулийг устгах мэдэгдэлд утгыг алдахгүйн тулд `%s` орлуулагчийг ашигладаг.

##### Example

Escape values by using the placeholder `%s` method:

`import mysql.connectormydb = mysql.connector.connect(  host="localhost",  user="yourusername",  password="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")`

               [https://www.addtoany.com/add_to/facebook?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-delete-from-by%2F&linkname=Python%20MySQL%C2%A0Delete%20From%20By](https://www.addtoany.com/add_to/facebook?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-delete-from-by%2F&linkname=Python%20MySQL%C2%A0Delete%20From%20By)[https://www.addtoany.com/add_to/mastodon?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-delete-from-by%2F&linkname=Python%20MySQL%C2%A0Delete%20From%20By](https://www.addtoany.com/add_to/mastodon?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-delete-from-by%2F&linkname=Python%20MySQL%C2%A0Delete%20From%20By)[https://www.addtoany.com/add_to/email?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-delete-from-by%2F&linkname=Python%20MySQL%C2%A0Delete%20From%20By](https://www.addtoany.com/add_to/email?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-delete-from-by%2F&linkname=Python%20MySQL%C2%A0Delete%20From%20By)[https://www.addtoany.com/share](https://www.addtoany.com/share)