Delete Record
You can delete anything from your database by given the delete record statement.
import mysql.connector
mycon = mysql.connector.connect(
host="localhost",
user="root",
passwd="1234",
database="college"
)
mycur = mycon.cursor()
mycur.execute("DELETE FROM students WHERE address = 'New Delhi'")
mycon.commit()
print(mycur.rowcount, "record(s) deleted")
Output
C:\Users\My Name>python demo.py 1 record(s) deleted
Delete Table
You can delete the table by using Drop table statement.
import mysql.connector
mycon = mysql.connector.connect(
host="localhost",
user="root",
passwd="1234",
database="college"
)
mycur = mycon.cursor()
mycur.execute("Drop table student")
Output
C:\Users\My Name>python demo.py