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

2 votes360 views2 answers
Create conda env with specific python version
Python
0 vote315 views2 answers
Python get sub count from youtube
Python
17 votes328 views10 answers
Javascript loop
Python
23 votes314 views2 answers
Converting month number to month name python
Python
1 vote335 views1 answer
ROLL D6
Python
1 vote304 views1 answer
Python remove non empty read only directory
Python
1 vote307 views1 answer
Simulate webcam and microphone selenium
Python
0 vote328 views1 answer
Labelencoder update
Python
0 vote320 views1 answer
Split coumn of df into multiple dynamic columns
Python
0 vote352 views2 answers
Python api with live ercot real time prices
Python