Fetch multiple values from database

Question

I get from my DB the following return, when I use the sql command SELECT DISTINCT RezeptID FROM Rezepte;:

((1L,), (13L,), (14L,), (15L,))

Now I want to work with this values. Normally I use for single values something like this:

a=cursor.execute(sql_command)
(a, )=cursor.fetchone()

But then I get of course only the first value, the "1" back. How can I work with all these values? It would be optimal when I can put all these values in a array

Eugene Yarmash · Accepted Answer · 2017-04-28 08:31:54Z

2

A cursor can be used as an iterator to iterate over rows in the result set. To get the first value from each row try this:

cursor.execute(sql)
values = [row[0] for row in cursor]

answered Apr 28, 2017 at 8:31

Eugene Yarmash

152k44 gold badges346 silver badges391 bronze badges

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

4 Comments

jofri Over a year ago

Okay, that works so far but the all the values in the list have an L behind the value. So the list looks so now : ´[1L, 13L, 14L, 15L]´

Eugene Yarmash Over a year ago

Check this question: stackoverflow.com/q/11764713/244297 Generally, you shouldn't have to worry about it.

Daniel Roseman Over a year ago

So what? That has no impact on anything.

jofri Over a year ago

Ah, okay now I got it. This L only shows that this are long values^^

CK Chen · Accepted Answer · 2017-04-28 08:27:08Z

0

cursor.fetchall() if you are using sqlalchemy.

answered Apr 28, 2017 at 8:27

CK Chen

7646 silver badges16 bronze badges

1 Comment

jofri Over a year ago

Yes, but when I use ´(a,b,c,d, )=cursor.fetchall()´ I get values like (1L, ) with the datatype tuple

Collectives™ on Stack Overflow

Fetch multiple values from database

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related