---
title: Python MySQL Drop Table
description: "## Delete a Table – Хүснэгт Устгах You can delete an existing table by using the “DROP TABLE” statement: Үүсгэгдсэн хүснэгтийг устгахын тулд “DROP TABLE” команд хэрэглэнэ: #### Example – Жишээ Delete the table “customers”: “customers” хүснэгтийг устгах: `import mysql.connectormydb =…"
url: "https://apprentice.mn/docs/python-mysql-drop-table/"
updated: "2024-08-05"
category: Python
---

# Python MySQL Drop Table

## Delete a Table – Хүснэгт Устгах

You can delete an existing table by using the “DROP TABLE” statement:

Үүсгэгдсэн хүснэгтийг устгахын тулд “DROP TABLE” команд хэрэглэнэ:

#### Example – Жишээ

Delete the table “customers”:

“customers” хүснэгтийг устгах:

`import mysql.connectormydb = mysql.connector.connect(  host="localhost",  user="yourusername",  password="yourpassword",  database="mydatabase")mycursor = mydb.cursor()sql = "DROP TABLE customers"mycursor.execute(sql)`

## Drop Only if Exist – Зөвхөн байх үед устгах 

If the table you want to delete is already deleted, or for any other reason does not exist, you can use the `IF EXISTS` keyword to avoid getting an error.

Устгах хүснэгт тань аль хэдийн устгагдсан эсвэл ямар нэгэн шалтгаанаар байхгүй бол `IF EXISTS` түлхүүр үгийг ашиглан алдаа авахгүй байж болно.

#### Example – Жишээ

Delete the table “customers” if it exists:

Хэрэв “customers” хүснэгт байгаа бол устгах:

`import mysql.connectormydb = mysql.connector.connect(  host="localhost",  user="yourusername",  password="yourpassword",  database="mydatabase")mycursor = mydb.cursor()sql = "DROP TABLE IF EXISTS customers"mycursor.execute(sql)`

               [https://www.addtoany.com/add_to/facebook?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-drop-table%2F&linkname=Python%20MySQL%C2%A0Drop%20Table](https://www.addtoany.com/add_to/facebook?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-drop-table%2F&linkname=Python%20MySQL%C2%A0Drop%20Table)[https://www.addtoany.com/add_to/mastodon?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-drop-table%2F&linkname=Python%20MySQL%C2%A0Drop%20Table](https://www.addtoany.com/add_to/mastodon?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-drop-table%2F&linkname=Python%20MySQL%C2%A0Drop%20Table)[https://www.addtoany.com/add_to/email?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-drop-table%2F&linkname=Python%20MySQL%C2%A0Drop%20Table](https://www.addtoany.com/add_to/email?linkurl=https%3A%2F%2Fapprentice.mn%2Fdocs%2Fpython-mysql-drop-table%2F&linkname=Python%20MySQL%C2%A0Drop%20Table)[https://www.addtoany.com/share](https://www.addtoany.com/share)