Generate single-dimensional array with MySQL query

Question

I have a simple 2 column table with the fields id and entry.

I want to select only the entries:

SELECT entry FROM table

However this query generates a multi dimensional array. I need to generate a simple, single-dimensional array. I know I could possibly do this after in my Phyhon code but the database is very large (100,000+ columns) and I'd like to not have to go through this extra step before I can exploit my data.

falsetru · Accepted Answer · 2013-12-21 08:24:38Z

1

Unpack the result as follow:

cursor.execute('SELECT entry FROM table')
rows = [entry for entry, in cursor.fetchall()]
#                      ^

>>> rows = [('entry1',), ('entry2',), ('entry3',)]
>>> rows
[('entry1',), ('entry2',), ('entry3',)]
>>> rows = [entry for entry, in rows]
>>> rows
['entry1', 'entry2', 'entry3']

answered Dec 21, 2013 at 8:24

falsetru

371k69 gold badges769 silver badges659 bronze badges

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

Collectives™ on Stack Overflow

Generate single-dimensional array with MySQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related