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 vote178 views1 answer
Cv2 put font on center
Python
28 votes176 views3 answers
Datetime one month ago python
Python
0 vote175 views1 answer
Items of a list not in another list python
Python
0 vote244 views1 answer
Nth catalan number
Python
0 vote168 views2 answers
# Plot the histogram of 'sex' attribute using Matplotlib # Use bins = 2 and rwidth = 0.85
Python
0 vote262 views1 answer
ValueError: Could not load "" Reason: "broken data stream when reading image file"
Python
1 vote201 views1 answer
Open chrome console in selenium
Python
0 vote182 views1 answer
Return the biggest even fro a list python
Python
0 vote249 views1 answer
Helper for FastAPI Users to create a super user
Python
1 vote188 views1 answer
Task timed out after 3.00 seconds aws lambda python
Python