python Mysql实现

#coding=utf-8

import MySQLdb

#建立数据库连接
conn = MySQLdb.connect(host="xxxxxxxxx",user='xxx',passwd='xxx',db='xxx',port=3306)
sql = "select * from CaboxProgram where tvId='xxx' and nibble1Id='xxx' and nibble2Id='xxx'"
#执行数据库操作
#cursor返回游标的连接对象
curs = conn.cursor()

curs.execute(sql)

res = curs.fetchall()

print type(res)   #返回是元祖
print len(res)
print res[0]
curs.close()
conn.close()

另附学习地址http://blog.csdn.net/lishan9133/article/details/7024989