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 vote153 views1 answer
Spevify datatype of column
Python
0 vote182 views1 answer
How to update image in django
Python Django
0 vote163 views1 answer
ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators > 1 char and different from '\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.
Python
2 votes148 views2 answers
How to change colour of rows in csv using pandas
Python
3 votes177 views1 answer
Flask secret key generator
Python Flask
3 votes141 views1 answer
Pandas plotly backend
Python
21 votes175 views6 answers
How to disable right click in js
Python
0 vote178 views1 answer
Root template
Python
1 vote144 views1 answer
How to count in a loop python
Python
0 vote151 views1 answer
Using shebang python
Python