Delete

Write Delete Query in Python to delete set of records in MySql Database.

Delete statement is used delete data from database. We pass a Code parameter to delete query and delete data from emp table.

#MySql – Python Delete Statement

File : delete_emp.py

from database_connection import *
mycursor=db_con.cursor()
query="delete from emp where code='a01'" # This will delete row with code a01, if it exists.
mycursor.execute(query)
db_con.commit()
mycursor.close()


#delete data form table emp based on input code from screen

mycursor=db_con.cursor()
pcode=raw_input("enter emplyee code to delete: ")
query="delete from emp where code=%s"
mycursor.execute(query,(pcode,))
db_con.commit()
mycursor.close()
db_con.close()

Result