[python]Python操作MySQL

【安装】

安装MySQL

安装MySQL不用多说了，下载下来安装就是，没有特别需要注意的地方。

一个下载地址：点击打开链接

【样例】

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62

# coding=utf-8 import MySQLdb   #查询数量 def Count(cur):    count=cur.execute('select * from Student')    print 'there has %s rows record' % count      #插入 def Insert(cur):    sql = "insert into Student(ID,Name,Age,Sex)values(%s,%s,%s,%s)"    param = (2,'xiaoming',24,'boy')    cur.execute(sql,param)   #查询 def  Select(cur):     n = cur.execute("select * from Student")       print "------"    for row in cur.fetchall():          for r in row:             print r       print "------"    #更新 def Update(cur):    sql = "update Student set Name = %s where ID = 2"      param = ("xiaoxue")       count = cur.execute(sql,param)   #删除 def Delete(cur):       sql = "delete from Student where Name = %s"      param =("xiaoxue")       n = cur.execute(sql,param)      try:    conn=MySQLdb.connect(host='localhost',user='root',passwd='123456',db='python',port=3306)    cur=conn.cursor()    #数量    Count(cur)    #查询    Select(cur)    #插入    Insert(cur)    print "插入之后"    #查询    Select(cur)    #更新    Update(cur)    print "更新之后"    #查询    Select(cur)    #删除    Delete(cur)    print "删除之后"    #查询    Select(cur)         cur.close()    conn.close()      except MySQLdb.Error,e:    print "Mysql Error %d: %s" % (e.args[0], e.args[1])