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.connector
mydb = 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.
Example – Жишээ #
Delete the table “customers” if it exists:
Хэрэв “customers” хүснэгт байгаа бол устгах:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DROP TABLE IF EXISTS customers"
mycursor.execute(sql)
