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

2 questions

Which of the following is true about MySQL Drop Table?

It is strictly typedIt is evaluated at runtimeIt requires explicit memory managementIt is deprecated

What is the most common pitfall when working with MySQL Drop Table?

SyntaxErrorIndentationErrorNameErrorTypeError

Answer all questions to submit.