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 : )