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

19 votes177 views1 answer
Python turn of userwarning
Python
2 votes186 views2 answers
How to code a yes or no question in python v3.8
Python
3 votes197 views1 answer
Drop duplicates pandas first column
Python
0 vote195 views1 answer
Pandas currency to numbe
Python
9 votes188 views6 answers
Flask – Environment
Python
0 vote192 views1 answer
Rqg3
Python
0 vote193 views2 answers
How to send one variable to python using xlwings
Python
2 votes318 views2 answers
Csv manipulation python
Python
2 votes194 views1 answer
Python clipboard to image
Python
1 vote216 views1 answer
How to bind close button in tkinter
Python