python 链接 mysql的一段代码

python连接mysql

#!/usr/bin/python
#coding=utf-8
import MySQLdb


conn=MySQLdb.connect(host="192.168.10.30",user="hive",passwd="123456",db="hive")
db = conn.cursor()
sql = 'select * from hive_backup where id=13213'
db.execute(sql)
for f in db.fetchall():
   print str(f).replace('\'','').replace('(','').replace(')','')
files.close()

刚开始学习python。能力有限。:-)