Write Python code to increase age of all employees by 1 year in the Employee table of database HTMdb with userid HRMan and password [email protected].
Answer:
import mysql.connector
mydb = mysql.connector.connect('localhost','HRMan','[email protected]','HRM')
cursor = mydb.cursor()
sql = "UPDATE Employee set Age=Age+1;"
try:
mydb.execute(sql)
mydb.commit()
except:
mydb.rollback()
cursor.close()
mydb.close()
Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class
