MySQL Drop Table 💥

Delete Table

You can delete an existing table by using the "DROP TABLE" statement.

✨ Drop Table

python

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.

python

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)

⚠️ Watch Out!

Be careful with the "DROP TABLE" statement. Deleting a table will result in loss of complete information stored in the table!