Write Python code to increase age of all employees by 1 year in the Employee table of database HTMdb with userid HRMan and password HRMANexe@pwd.
Answer:
import mysql.connector
mydb = mysql.connector.connect('localhost','HRMan','HRMANexe@pwd','HRM')
cursor = mydb.cursor()
sql = "UPDATE Employee set Age=Age+1;"
try:
mydb.execute(sql)
mydb.commit()
except:
mydb.rollback()
cursor.close()
mydb.close()
