Question 3 - Past Year - 3 Mark Questions - Chapter 15 - Interface of Python with SQL Database

Consider the following table OrderDetails of database sales

Write Python code to increase NUMBORD by 5 if QUOTPRIC is less than 100 or NUMBORD is greater than 3.

Answer:

import mysql.connector.connect

db=mysql.connector.connect('localhost','root','root','sales')

cursor=db.cursor()

sql="UPDATE OrderDetails set NUMBORD=NUMBORD+5 where QUOTPRIC<100 OR NUMBORD>3"

try:

cursor.execute(sql)

db.commit()

except:

db.rollback()

db.close()