title: How do you change the SQL isolation level from Python using MySQLdb?
body: <p>The documentation I've run across researching this indicates that the way to do it for other databases is to use multiple statements in your query, a la:</p>
  
  <pre><code>&gt;&gt;&gt; cursor = connection.cursor()
  &gt;&gt;&gt; cursor.execute("set session transaction isolation level read uncommitted; 
                      select stuff from table; 
                      set session transaction isolation level repeatable read;")
  </code></pre>
  
  <p>Unfortunately, doing that yields no results, as apparently the Python DB API (or maybe just this implementation of it?) doesn't support multiple recordsets within a single query.</p>
  
  <p>Has anyone else had success with this in the past?</p>