python fetchall返回的格式_Python MySQLDB：在列表中获取fetchall的结果

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]. I am trying to avoid the manually looping over the items. Thanks in advance

解决方案

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]