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 vote89 views1 answer
How to get started with flask
Python
1 vote127 views1 answer
How tyo make a constantly adding variable in python
Python
0 vote133 views1 answer
Xtick for axvline
Python
19 votes133 views5 answers
Conda tensorflow
Python
6 votes136 views3 answers
Pandas create dataframe from multiple dictionaries
Python
0 vote140 views1 answer
Tkinter filedialog get directory path
Python
4 votes138 views4 answers
Speech to write anything python code
Python
0 vote147 views1 answer
Python regex (\d)(?=\d\1)
Python
0 vote86 views1 answer
Create a class patient with below attributes in Python
Python
0 vote97 views1 answer
Pafy documentation
Python