Store output of mysql select statement as python list

Question

I have a very large table in mysql that I'm accessing through a python script, and I'd like the output of my select query to be stored as a list. Here's what I have:

import MySQLdb
db = MySQLdb.connect(host='', user='', passwd='', db='')
cursor = db.cursor()

sqlselect = "SELECT desig FROM table WHERE num=0;"
desigs = cursor.execute(sqlselect)
print desigs

But this just gives me the number of rows in set which is nearly 250,000. Instead, I'd like it to print a list of each 'desig'. How can I do this?

That should be cursor and not desigs right after execute is called. — Oluwafemi Sule
– Oluwafemi Sule, Commented Sep 20, 2017 at 22:47

Danielle M. · Accepted Answer · 2017-09-20 23:17:35Z

1

cursor.execute() will return the number of rows modified or retrieved.

Once you've executed the query, run cursor.fetchall(), which will return you an array containing each row in your query results. That is, you get an array of arrays.

Edit: list! list of lists!! argh

edited Sep 20, 2017 at 23:17

answered Sep 20, 2017 at 22:43

Danielle M.

3,6901 gold badge16 silver badges33 bronze badges

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

2 Comments

Barmar Over a year ago

Don't you mean list of lists?

Danielle M. Over a year ago

@Barmar dang it, I had just used array to describe a list somewhere else, and it leaked into stackexchange, how embarrassing. I'll leave it up to teach myself a lesson.

Collectives™ on Stack Overflow

Store output of mysql select statement as python list

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related