Python写的一个sql查询，返回字段和数值，有序

import MySQLdb
import datetime

conn = MySQLdb.connect(user='360_hqb', passwd='360hqb', host='127.0.0.1', port=3306)
conn.select_db('okhqb')
cursor = conn.cursor() 
cursor.execute("SET NAMES 'utf8'")

cursor.execute('SELECT s.* FROM is_sales_order s WHERE s.`unhouse_time` IS not NULL LIMIT 2')

# 全部结果放在一个大的list
columnNames = []

# 查询SQL的返回值属性list
for field in cursor.description:
    columnNames.append(field[0])

# 将属性值list放入外部大list集合
allResults = [columnNames];

# 查询数据结果集
res = cursor.fetchall()  
for row in res:
    tempRes = []
    for r in row:
        tmp = r 
        if r is not None and type(r) is datetime.datetime:
            tmp = datetime.datetime.strftime(r, '%Y-%m-%d %H:%M:%S')
        tempRes.append(tmp)
    
    allResults.append(tempRes)

print allResults

conn.commit()
cursor.close()