Python program to delete a record from database using its ID (Example 2)

Program to delete a record from database using its ID

import pymysql as MYSQL
try:
 conn=MYSQL.connect(host='localhost',port=3306,
    user='root',password='123',db='practice')

 cmd=conn.cursor()

 id=input("Enter Product Id U Want to Delete:")

 q="select * from products where productid={}".format(id)
 cmd.execute(q)

 row=cmd.fetchone()
 if(row==None):
     print("Record Not Found")
 else:
     #print(row)
    print("Product Id:",row[0])
    print("Product Name:",row[1])
    print("Product Price:",row[2])
    print("Product Date:",row[3])
    ch=input("Are U Sure Yes/No?")
    if(ch.lower()=='yes'):
     q="delete from products where productid={}".format(id)
     cmd.execute(q)
     print("Record Deleted....")

 conn.commit()
 conn.close()
except Exception as e:
    print(e)

Output:

Enter Product Id U Want to Delete:47
Product ID:47
Product Name:cPhone Prime
Product Price:12499
Product Date: 27/10/2020
Are U Sure yes/no?yes
Record Deleted...