Program20.py

import mysql.connector as mycon

con = mycon.connect(host='127.0.0.1', user='root', password="admin", database="company")
cur = con.cursor()

print("#" * 40)
print("EMPLOYEE DELETION FORM")
print("#" * 40)
print("\n\n")

ans = 'y'
while ans.lower() == 'y':
    eno = int(input("ENTER EMPNO TO DELETE: "))
    query = "SELECT * FROM employee WHERE empno={}".format(eno)
    cur.execute(query)
    result = cur.fetchall()
    
    if cur.rowcount == 0:
        print("Sorry! Empno not found.")
    else:
        print("%10s" % "EMPNO", "%20s" % "NAME", "%15s" % "DEPARTMENT", "%10s" % "SALARY")
        for row in result:
            print("%10s" % row[0], "%20s" % row[1], "%15s" % row[2], "%10s" % row[3])
        
        choice = input("\n## ARE YOU SURE TO DELETE? (Y): ")
        if choice.lower() == 'y':
            query = "DELETE FROM employee WHERE empno={}".format(eno)
            cur.execute(query)
            con.commit()
            print("=== RECORD DELETED SUCCESSFULLY! ===")

    ans = input("DELETE MORE? (Y): ")