MySQL Database
Kevin Holleran
kdawg44 at gmail.com
Wed May 8 14:52:59 EDT 2013
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>
More information about the Python-list
mailing list