Python Tutorials · Python MySQL

MySQL Drop Table

Learn all about MySQL Drop Table in this comprehensive tutorial.

5 min read advanced

MySQL Delete

MySQL Update

•You can delete an existing table by using the "DROP TABLE" statement:
•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.

Delete a Table

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

python

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.

python

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)

Module quiz

Test your knowledge on this module

5 questions