Python Program - Database - DELETE Operation:

• Delete Example

  #!/usr/bin/python
  
  import MySQLdb
  
  # Open database connection
  
  db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )
  
  # prepare a cursor object using cursor() method
  cursor = db.cursor()
  
  # Prepare SQL query to DELETE required records
  sql = "DELETE FROM EMPLOYEE WHERE AGE > '%d'" % (20)
  try:
       # Execute the SQL command
       cursor.execute(sql)
       # Commit your changes in the database
       db.commit()
  except:
       # Rollback in case there is any error
       db.rollback()
  
  # disconnect from server
  db.close()