title: Can't create temporary tables through Python (Mysql.Connector)
body: <p>I have a query of the following format,</p>
  
  <p><code>DROP TABLE X;
   CREATE TEMPORARY TABLE IF NOT EXISTS X (SELECT * FROM TABLE); 
   SELECT A,B,C FROM X;</code></p>
  
  <p>However, if I run this in Python using mysql connector. I get the following message, <code>'No result set to fetch from'</code>.
  My understanding is that it only executes the first <code>DROP TABLE X;</code> and returns. 
  Is there another way to achieve this?. I've also tried using <code>multi=True</code> but that didn't work either.
  Thanks in advance</p>