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

37 votes184 views6 answers
Lambda in python
Python
0 vote180 views1 answer
Add percentage column pandas
Python
2 votes169 views1 answer
Get guild from a channel discord py
Python
1 vote175 views1 answer
Python strftime microseconds
Python
0 vote153 views1 answer
Len of square matrix
Python
0 vote177 views1 answer
IndexError: tuple index out of range
Python
0 vote202 views1 answer
How to make python open a program/desktop app
Python
16 votes194 views1 answer
Python reload file if changed
Python
6 votes208 views1 answer
Pip freeze showing @ and not showing package version
Python
0 vote197 views1 answer
Django never_cache example
Python