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