#-*- coding:utf8 -*-
import MySQLdb
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
try:
conn=MySQLdb.connect(host='localhost',user='root',passwd='r66t',db='mytest',charset='utf8',port=3306)
cur=conn.cursor()
#插入一条数据
# sqli="insert into myuser(user_name,user_pwd) values(%s,%s)"
# cur.execute(sqli,('Huhu','asdasdasd'))
# conn.commit()
result = cur.execute("select * from myuser")
#打印表中的多少数据
# info = cur.fetchmany(result)#接收size条返回结果
# for ii in info:
# print ii[1]
# info = cur.fetchall()#接收全部返回结果
# for each in info:
# print each
info = cur.fetchone();#(1,"name","pwd")
for each in info:
print each
#更新
# sql = "update myuser set user_name=%s where user_id=5"
# param = ("bbb")
# n = cur.execute(sql,param)
# print n
cur.close()
conn.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
mysql模块链接:
http://pan.baidu.com/s/1kUf61Ll