Instance Six:使用Prepared statements执行查询（更安全方便）

#!/usr/bin/env python
#--*-- coding:utf-8 --*--
__author__ = 'Kevin'

import MySQLdb as mdb
import sys

con = mdb.connect('localhost','root','redhat','test')

try:
    with con:
        cur = con.cursor()
        cur.execute("UPDATE Writers SET Name = %s WHERE Id = %s",("Guy de Maupasant","3"))
    print "Number of rows updated: %d" % cur.rowcount
finally:
    con.close()

 Result:

Number of rows updated: 1