python访问MySQL数据库

# -*- coding: utf-8 -*-
#encoding=utf-8
import MySQLdb
        
def insert_attachment(file_name,md5,email_id,email_address,date):
    try:
        conn=MySQLdb.connect(host='localhost',user='root',passwd='root',db='test',port=3306,charset='gbk')
        cur=conn.cursor()
        sql_content="insert into attachment(file_name,md5,email_id,email_address,date) values ('%s','%s','%s','%s','%s')" %(file_name,md5,email_id,email_address,date)
                #print(file_name)
        cur.execute(sql_content)
        print("insert success!"+sql_content)
        cur.close()
        conn.commit()
        conn.close()
    except MySQLdb.Error,e:
        print "Mysql Error %d: %s" %(e.args[0],e.args[1])
      
      
   
注意：%s两边的引号。