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 vote297 views1 answer
Getting heading from a webpage in beautifulsoup
Python
0 vote284 views1 answer
Get fields in object python
Python
0 vote336 views1 answer
Python - regexp to find part of an email address
Python
0 vote269 views1 answer
File "pandas/_libs/index.pyx", line 465, in pandas._libs.index.DatetimeEngine.get_loc KeyError: Timestamp('2019-01-02 07:09:00')
Python
0 vote273 views1 answer
Python create local list
Python
0 vote284 views1 answer
Legend outside subplot not displayed
Python
0 vote312 views2 answers
Set operators
Python
-1 vote301 views1 answer
Converting multipage tiff to pdf python
Python
0 vote300 views1 answer
Pretty print list python
Python
0 vote329 views1 answer
Pandas sort values reset index
Python