python学习 第七篇 sql优化
>>> fields=["id","name","name_cn","email","mobile"]>>> sql="select %s from users where name ='admin'" % ','.join(fields)
>>> sql
"select id,name,name_cn,email,mobile from users where name ='admin'"
>>> cur.execute(sql)
1L
>>> res=cur.fetchone()
>>> res
(16L, u'admin', u'admin', u'134556', u'123455')
>>> user={}
>>> for i,k in enumerate(fields):
... user=res
...
>>> user
{'mobile': u'123455', 'email': u'134556', 'name_cn': u'admin', 'id': 16L, 'name': u'admin'}
>>> for i,k in enumerate(fields):
... print i,k i 是索引值，k是fields 里面的值
...
0 id
1 name
2 name_cn
3 email
4 mobile
>>> res
u'admin'
页:
[1]