How to iterate through cursor after mysql select * query in python?

Question

I am querying all the fields of a mysql table like this -

query = """select * from %s where %s=%s;""" % (tableName,key,value)
cursor.execute(query)

Now, I would like to iterate over the results. I do not want to specify the column names which I would like to fetch as I would like to fetch all. This is part of a generic migration verification script which is supposed to do the verification for all the mysql tables. Since there will be different number of columns in different tables, I would like a general solution.

I checked https://stackoverflow.com/a/25347195/351903 but it involves specific fields.

Siegmeyer · Accepted Answer · 2018-07-31 12:33:31Z

2

MySQLdb conforms to PEP-249.

Therefore,execute must return an iterator. You can just do:

for tupl in cursor.execute(query):
    pass

where tupl is a tuple.

*Alternatively, you can use fetchone, fetchmany(n) or fetchall() to evaluate at once.

edited Jul 31, 2018 at 12:33

answered Jul 31, 2018 at 12:29

Siegmeyer

4,5427 gold badges29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sandeepan Nath Over a year ago

Yes it works. I did some wrong observation it seems.

Deepak Kumar · Accepted Answer · 2018-07-31 12:28:55Z

0

First run below query

sp_help Table

then get the column names from that

after that run your code. Because you will have column names.

I also created this type of utility. That was windows console app.

answered Jul 31, 2018 at 12:28

Deepak Kumar

6666 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to iterate through cursor after mysql select * query in python?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related