python学习之使用mysql

来源：互联网发布：淘宝自定义内容区代码编辑：程序博客网时间：2024/06/15 19:49

#-*- coding:utf8 -*-import MySQLdbimport sysreload(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

0 0