Update specific cell in mySQL using python

Question

I've been using mySQLdb in python to import data into a database, however I would also like to be able to address a specific row and update a cell in that row, I couldn't find the command to do this in the mySQLdb help file, would anyone be kind enough to point me in the right direction...

Thanks,

Community · Accepted Answer · 2017-05-23 10:24:49Z

1

You can use a sql UPDATE statement

psuedo data schema:

# table people
id INT, name VARCHAR(40), age INT, address VARCHAR(100)

1, john, 33, North America
2, dm03514, 28, Maryland

using pythong MySQLdb

cursor.execute('UPDATE people SET address = %s WHERE id = %s', ('Columbia, MD', 2));

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Feb 4, 2013 at 18:10

dm03514

56.1k18 gold badges117 silver badges147 bronze badges

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

Collectives™ on Stack Overflow

Update specific cell in mySQL using python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related