1,
conn=MySQLdb.Connect(host='localhost',user='root',passwd='',db='test',compress=1,cursorclass=MySQLdb.cursors.DictCursor)
cursor=conn.cursor()
2,
c = self.db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
c.execute(query)
rows = c.fetchall()
3,
defFetchOneAssoc(cursor) :
data = cursor.fetchone()
if data == None :
return None
desc = cursor.description
dict = {}
for (name, value) in zip(desc, data) :
dict[name[0]] = value
return dict
4,
cursor.execute('select sum(id) as sumid from tb;')
key为‘sum(id)’
cursor.execute('select sum(id) as sid as sumid from tb;')
key为‘sid’