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

zidong

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()