Cursor.fetchall() to list

And what about list comprehensions? If result is ((123,), (234,), (345,)):

>>> row = [item[0] for item in cursor.fetchall()]
>>> row
[123, 234, 345]

If result is ({'id': 123}, {'id': 234}, {'id': 345}):

>>> row = [item['id'] for item in cursor.fetchall()]
>>> row
[123, 234, 345]

--César

Similar codes

0 vote380 views1 answer
Mylist = [“hello”, “bye”,”see ya”,”later”] phrase = mylist[1]
Python
0 vote353 views2 answers
How to make a function input optional in python
Python
1 vote371 views1 answer
Df.fillna(-999,inplace=True)
Python
2 votes327 views1 answer
Numpy how to slice individual columns
Python
81 votes357 views6 answers
Python string to datetime
Python
0 vote344 views1 answer
How to write a first program in machine learning
Python
0 vote384 views1 answer
Pandas not is na
Python
0 vote406 views1 answer
Python use math
Python
140 votes347 views6 answers
Python random integer in range
Python
7 votes364 views2 answers
Python string to array
Python