MySQLdb是Python 連接 MySQL 的模塊，下面是它一些簡單的使用方法：

# -- coding: utf-8 --

mysqldb
import time, MySQLdb
連接
conn=MySQLdb.connect(host="localhost",user="root",passwd="",db="test",charset="utf8")

cursor = conn.cursor()
寫入
sql = "insert into user(name,created) values(%s,%s)"

param = ("aaa",int(time.time()))

n = cursor.execute(sql,param)

print n
更新
sql = "update user set name=%s where id=3"

param = ("bbb")

n = cursor.execute(sql,param)

print n
查詢
n = cursor.execute("select * from user")

for row in cursor.fetchall():

    for r in row:

        print r
刪除
sql = "delete from user where name=%s"

param =("aaa")

n = cursor.execute(sql,param)

print n

cursor.close()
關閉
conn.close()</pre> 本文由 
坤子的blog 原創