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

 

Get Real time Doubt solving from 8pm to 12 am!

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.