How to use PREPARED statements in pyhon-mysql?

[He Yu]

I've figured a plausible way of using several PREPARED statements in mysql 5.0 :
open connection
cursor.execute('prepare stmt1 from "..."')
cursor.execute('prepare stmt2 from "..."')
...
loop:
cursor.execute('set ...')
cursor.execute('execute stmt1 using (...)')
cursor.execute('set ...')
cursor.execute('execute stmt2 using (...)')
...
cursor.execute('deallocate prepare stmt1')
cursor.execute('deallocate prepare stmt2')
close connection

I try to put 'set'/'execute' in one clause, but it fails after executing a few. The current way incurs additional cost of executing 'set'. Most important of all, the performance is the same as that not using prepare.

Does Py-MySQL provide any better support for PREPARED statements, rather than executemany()?