Python将mysql中select语句返回的多行数据转换为list

简单记录一下，用到了chain方法。

from itertools import chain
...
sql="select elems from table"
cursor.execute(sql)
elems = cursor.fetchall()
resultlist = list(chain.from_iterable(elems))
...