$ apt-cache search python | grep mysql
python-mysqldb - A Python interface to MySQL
python-mysqldb-dbg - A Python interface to MySQL (debug extension)

$ sudo apt-get install python-mysqldb		
		

# -*- 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 = ("neo",int(time.time()))    
n = cursor.execute(sql,param) 
print n    
   
#更新    
sql = "update user set name=%s where id=3"   
param = ("jam")    
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 =("neo")    
n = cursor.execute(sql,param)    
print n    
cursor.close()    
   
#关闭    
conn.close()   		
		

原文出处：Netkiller 系列 手札
本文作者：陈景峯
转载请与作者联系，同时请务必标明文章原始出处和作者信息及本声明。