[python]Python操作MySQL

標籤：python   mysql   

【安裝】

安裝MySQL

安裝MySQL不用多說了，下載下來安裝就是，沒有特別需要注意的地方。

一個：點擊開啟連結

【範例】

# coding=utf-8import 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])

[python]Python操作MySQL