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
Subscribe Now