How one can Drop a MySQL Desk in Python

First, you will want the mysql.connector. If you’re not sure of get this setup, consult with How one can Set up MySQL Driver in Python.

How one can Delete/Drop a MySQL Desk in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
sql = "DROP TABLE prospects"
mycursor.execute(sql)

How one can Delete/Drop Provided that MySQL Desk Exists in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
sql = "DROP TABLE IF EXISTS prospects"
mycursor.execute(sql)