MySQL Database

[Kevin Holleran]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20130508/cd6aed3c/attachment.html>