Cursor.execute does not work in Python

Question

I am using MySQLdb package in Python to update my database. I have a simple update command as follows :

update_query = "update user_details set `address`='%s' where `id`='%s'"
cursor.execute(update_query, (address, id1))
print(cursor._last_executed)

Here is the command executed :

update user_details set `address`='35, Chikmagalur' where `id`='242069'

The program runs fine without error. However, the database is not getting updated. The same command works when I run as an SQL query on PHPMyAdmin.

Any idea what could be the issue ?

sinaiy · Accepted Answer · 2018-05-01 11:44:29Z

3

this is a duplicate of ...

sql transactions needs to be committed, either explicitly or implicitly.

either issue a commit command explicitly cursor._get_db().commit()

setting the connection to autocommit when opening the connection is also an option.

edited May 1, 2018 at 11:44

answered May 1, 2018 at 11:40

sinaiy

1169 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Kiran Over a year ago

I have enabled autocommit. Here is the code : db = MySQLdb.connect(host=host, port=port, user=username, passwd=password, db=database, cursorclass=MySQLdb.cursors.DictCursor) db.autocommit = True cursor = db.cursor() But it doesnt work either

sinaiy Over a year ago

you can see the number of effected rows, print(cursor.execute(update_query, (address, id1)))

Kiran Over a year ago

It says 1 ( 1 row is affected ). However there is no change in the table whasover. Strange

Ravinder Reddy Over a year ago

@kiran: check if the db you are checking in is same as the one used in the code

Kiran Over a year ago

cursor._get_db().commit() worked. However autocommit was enabled to true. Thanks @sinaiy for the help

Collectives™ on Stack Overflow

Cursor.execute does not work in Python

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related