Python使用MySQLdb创建、调用MySQL存储过程

import MySQLdb

conn = MySQLdb.connect(host='192.168.100.56',user='chang',passwd='123456',db='test')
print "connection is ok!"

conn.autocommit(False)
#conn.autocommit(True)

cursor = conn.cursor()

#MySQLdb execute can craete procedure
sql = "CREATE PROCEDURE demo_proc(IN p_in int,OUT p_out int) \
BEGIN \
     set p_out=2; \
END"
cursor.execute(sql)
print "procedure created suceefully!!"

def func(procname,seq):
    sql = "select "
    paralist = list(seq)
    j = 0
    for i in paralist:
        paralist[j] = "@_"+procname+"_"+str(i)
        j=j+1
    delimiter = ','
    paralist = delimiter.join(paralist)
    sql = sql + paralist
    return sql
seq = (0,1)
name = 'demo_proc'
sql = f