title: multiple sql in python
body: <p>i am trying to send two SQL ( select and update) in one python file. but getting still error</p>
  
  <pre><code>  cursor = cnx.cursor()
    query = "select id, mail from `candidats`; UPDATE candidats SET statusmail=1 "
    results = cursor.execute(query, multi=True)
    for cur in results:
      print('cursor:', cur)
      print('result:', cur.fetchall())
    cursor.close()
    cnx.close()
  </code></pre>
  
  <p>getting this error:</p>
  
  <pre><code>mysql.connector.errors.InterfaceError: No result set to fetch from
  </code></pre>