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

8 votes288 views2 answers
Loop through list backwards python
Python
0 vote281 views1 answer
How to get ping from computer IN PYTHON
Python
2 votes246 views6 answers
E: Could not get lock /var/lib/dpkg/lock-frontend - open (11: Resource temporarily unavailable)
Python
0 vote279 views1 answer
Python filter timestamp
Python
38 votes284 views2 answers
How to file in python
Python
0 vote296 views1 answer
Python subprocess stdout to dev null
Python
1 vote308 views1 answer
How to set "Unnamed: 0" column as the index in a DataFrame
Python
1 vote267 views1 answer
A function to create a null correlation heatmap in python
Python
4 votes263 views1 answer
List of df to df
Python
3 votes285 views2 answers
Vertical line in matplotlib
Python