Python Basics

Python PyMySQL Update Record

In some cases, we may want to update table data using update sql statement. Lets see how can we update.

The table which I am using to update record is as below.

emp_id emp_name emp_age
1 Raj 22
2 Rahul 24
3 Vivek 26
4 Ajay 28
5 Suraj 29

In the above table, lets say, I want to update the emp_name from Vivek to Birju whose id is 3.

If you have understanding of pymysql insert statement then following code is just a piece of cake for you. I have already discussed about insert statement. So check that tutorial.

Update Record

conn=pymysql.connect(‘localhost’,’root’,”,’emp_db’)

cursor=conn.cursor()

sql=”update emp_info set emp_name=’%s’ where id=%d ”

dataval=(‘Birju’,3)

try:

cursor.execute(sql)

conn.commit()

print(“data updated successfully”)

else pymysql.Error as pe:

print(pe)

conn.rollback()

finally:

cursor.close()

conn.close()

Output: data updated successfully

Note: Because we have changed the data in the table, so we must have to call conn.commit()  function to make the changes permanent in the table.