Delete a Table
You can delete an existing table by using the “DROP TABLE” statement:
Example
Delete the table “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)
#If this page was executed with no error(s), you have successfully deleted the “customers” table.
Output:
C:\Users\My Name>python demo_mysql_drop_table.py
Drop Only if Exist
If the 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:
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)
#If this page was executed with no error(s), you have successfully deleted the “customers” table.
Output:
C:\Users\My Name>python demo_mysql_drop_table2.py