Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #44957

MySQL Database

Show all headers | View raw

[Multipart message — attachments visible in raw view] - view raw

Hello,

I want to connect to a MySQL database, query for some records, manipulate
some data, and then update the database.

When I do something like this:

    db_c.execute("SELECT a, b FROM Users")

    for row in db_c.fetchall():

        (r,d) = row[0].split('|')

        (g,e) = domain.split('.')

        db_c.execute("UPDATE Users SET g = '" + g + "' WHERE a ='" + row[0])

Will using db_c to update the database mess up the loop that is cycling
through db_c.fetchall()?

Thanks for your help.

Kevin

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

MySQL Database Kevin Holleran <kdawg44@gmail.com> - 2013-05-08 14:52 -0400

csiph-web