Thanks, I actually intend to, was just whipping something up to be an
example for my question.
--
Kevin Holleran
Master of Science, Computer Information Systems
Grand Valley State University
Master of Business Administration
Western Michigan University
GCFA, GCFE, CCNA, ISA, MCSA, MCDST, MCP
"
On 08/05/2013 19:52, Kevin Holleran wrote:
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].
On Wed, May 8, 2013 at 2:56 PM, Chris Angelico wrote:
> On Thu, May 9, 2013 at 4:52 AM, Kevin Holleran wrote:
> > Will using db_c to update the database mess up the loop that is cycling
> > through db_c.fetchall()?
>
> Nope; fetchall() returns a list, which you're then iterating over.
> Nothing
On Thu, May 9, 2013 at 4:52 AM, Kevin Holleran wrote:
> Will using db_c to update the database mess up the loop that is cycling
> through db_c.fetchall()?
Nope; fetchall() returns a list, which you're then iterating over.
Nothing the database does can disrupt that.
ChrisA
--
http://mail.python.
On 22/03/2013 16:01, Roy Smith wrote:
> What are my options for MySQL schema discovery? I want to be able to
> find all the tables in a database, and discover the names and types of
> each column (i.e. the standard schema discovery stuff).
>
> PEP 249 doesn't seem to have any discovery methods.