python操作mysql基础之select

# -*- coding: utf-8 -*-

import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='root',db='cb',port=3306,charset='utf8')
cur = conn.cursor()
goods = cur.execute("select goods_name from es_goods where goods_id=59")
esGoods = cur.fetchmany(goods)
for i in esGoods:
    print i[0]
cur.close
conn.commit()
conn.close