Q. Write a program to increase salary of the employee, whose name is "MANOJ KUMAR", by 3000.


Answer =


import mysql.connector as a
db = a.connect(host="localhost",user="root",password="computer", database = "portal_express")

cursor = db.cursor() 

cursor.execute("update Path_wala set salary = salary + 3000 where name = 'MANOJ KUMAR' ")
db.commit() 
db.close()



Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post