Check sibling questions
Computer Science - Class 12
Chapter 15 - Interface of Python with SQL Database

Consider the table Product with following structure.

P_ID, ProductName, Manufacturer, Price.

Write Python code to increase the price of all products by 50.

 

Answer:

import mysql.connector

 

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

cursor=mydb.cursor()

sql="update product set price=price+50;"

try:

cursor.execute(sql)

mydb.commit()

except:

mydb.rollback()

cursor.close()

mydb.close

 

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.