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

7 votes181 views1 answer
Python if else short version
Python
0 vote130 views1 answer
Sentence similarity spacy
Python
101 votes91 views10 answers
Read files python
Python
0 vote182 views1 answer
Whitelist the ip address django
Python Django
0 vote154 views1 answer
Group a dataset
Python
2 votes188 views1 answer
Flask if statement
Python Flask
0 vote133 views1 answer
Add data to foreign key table django
Python Django
1 vote145 views1 answer
Python dictionary with list
Python
0 vote147 views1 answer
Pandas dataframe macd
Python
7 votes147 views2 answers
How to get the remainder of a number when dividing in python
Python