Python MySQLDB: Get the result of fetchall in a list
django, mysql-python, python
Solution
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]
Problem
I would like to get the result of the fetchall operation in a list instead of tuple of tuple or tuple of dictionaries. For example, ``` cursor = connection.cursor() #Cursor could be a normal cursor or dict cursor query = "Select id from bs" cursor.execute(query) row = cursor.fetchall() ``` Now, the problem is the resultant row is either ((123,),(234,)) or ({'id':123}, {'id':234}) What I am looking for is (123,234) or [123,234]. Be best if I can save on parsing the resulset.