What's wrong with my Python code to update MySQL table where ID = an integer?

Question

>>> print x 
 [(1,), (2,), (3,), (4,), (5,), (6,), (7,), (8,), (9,), (10,)]

>>> for i in range(10):
...     if len(x)>0:
...             m = random.choice(x)
...             x.remove(m)
...             y = "%s" %m
...             z = int(y)
...             cur.execute("""UPDATE accounts SET column = 'YES' WHERE userid = %s""", (z, ))

This doesn't do anything though. When I view the accounts table, nothing's changed.

Community · Accepted Answer · 2017-05-23 11:59:52Z

3

You need to commit the changes after the update:

db.commit()

where db is a database connection instance (the result of connect() call).

Also see: Database does not update automatically with MySQL and Python.

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Jun 25, 2014 at 14:06

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

2 Comments

user3465521 Over a year ago

sunnuva! I always forget that.. thank you so much sorry for this ignorant post

glglgl Over a year ago

@user262064 You might want to create your cursor like with connection as cursor: immediately above the for loop. Then it will automatically commit() on success or rollback() on error.

Collectives™ on Stack Overflow

What's wrong with my Python code to update MySQL table where ID = an integer?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related