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 vote267 views1 answer
Check if value in dictionary keys python dataframe
Python
32 votes239 views4 answers
Python pip install matplotlib
Python
0 vote267 views1 answer
Python how to request query string korean encode
Python
1 vote252 views1 answer
Feet to meter python
Python
1 vote256 views1 answer
Numpy isinstance
Python
18 votes257 views6 answers
Addition in python
Python
-3 votes261 views1 answer
Django socketio web chat example
Python
0 vote266 views1 answer
Insertar en una lista anidada python
Python
0 vote264 views1 answer
Ping all IP addresses in a network
Python
2 votes285 views1 answer
ValueError: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True site:stackoverflow.com
Python