python_mysql_delete_tables.py

import mysql.connector
def main():
    mydb = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="thedatabase"
    )
    #Creates a connection to the DB
    mycursor = mydb.cursor()

    sql = "DROP TABLE customers"

    mycursor.execute(sql)


if __name__ == '__main__':
    main()