title: Problem with executing query in python using cursor.execute()
body: <p>I have a <code>set</code> function followed by <code>;</code> in my query and cursor.execute thinks I'm running multiple queries and says use `multiple=true' but in fact I'm just running one query.
  How can I tell python consider my whole string a single query?</p>
  
  <pre><code>agent_report_query = """
  </code></pre>
  
  <p><code>set</code> @StartDate = <code>'2020-04-01 00:00:00'</code>;</p>
  
  <p><code>set</code> @EndDate = <code>'2020-04-02 00:00:00'</code>;</p>
  
  <p><code>SELECT</code>
      Date,
      Name
  <code>FROM</code> tbl</p>
  
  <p><code>WHERE</code>
      user_calculated_data.date >= @StartDate
  <code>And</code>
      user_calculated_data.date &lt; @EndDate</p>
  
  <pre><code>"""
  </code></pre>
  
  <p>then I execute this:</p>
  
  <pre><code>    cursor2 = con2.cursor()
      cursor2.execute(agent_report_query)
      AgentReport = cursor2.fetchall()
      print("AgentReport Query executed successfully!")
      for i in AgentReport:
         print(i)
  </code></pre>
  
  <p>And the result is: </p>
  
  <p>mysql.connector.errors.InterfaceError: Use multi=True when executing multiple statements</p>
  
  <p>if I use: <code>cursor2.execute(agent_report_query,multi=False)</code></p>
  
  <p>the result is:</p>
  
  <p>mysql.connector.errors.InterfaceError: No result set to fetch from.</p>
  
  <p><strong>could you please help me?</strong></p>