title: Suggested way to run multiple sql statements in python?
body: <p>What would be the suggested way to run something like the following in python:</p>
  <pre><code>self.cursor.execute('SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS %s; SET FOREIGN_KEY_CHECKS=1' % (table_name,))
  </code></pre>
  <p>For example, should this be three separate <code>self.cursor.execute(...)</code> statements? Is there a specific method that should be used other than <code>cursor.execute(...)</code> to do something like this, or what is the suggested practice for doing this? Currently the code I have is as follows:</p>
  <pre><code>self.cursor.execute('SET FOREIGN_KEY_CHECKS=0;')
  self.cursor.execute('DROP TABLE IF EXISTS %s;' % (table_name,))
  self.cursor.execute('SET FOREIGN_KEY_CHECKS=1;')
  self.cursor.execute('CREATE TABLE %s select * from mytable;' % (table_name,))
  </code></pre>
  <p>As you can see, everything is run separately...so I'm not sure if this is a good idea or not (or rather -- what the best way to do the above is). Perhaps <code>BEGIN...END</code> ?</p>