title: Can't get the desired output in the official MySQL connector
body: <p>I use Python to connect to MariaDB. I recently switched from the PyMySQL to the native connector from <a href="http://dev.mysql.com/doc/connector-python/en/index.html" rel="nofollow">this page</a> and I can't get to work this simple code:</p>
  
  <pre><code>a = mysql.connect(host='127.0.0.1', port=3306, user='root', db='db', passwd='1337')
  b = a.cursor()
  b.execute('SELECT * FROM accounts', multi=True)
  b.execute('SELECT * FROM profile', multi=True)
  print(b.fetchall())
  a.commit()
  </code></pre>
  
  <p>I thought it would print all the rows from the <code>profile</code> table, but for some reason it does not, and exits with the following error</p>
  
  <pre class="lang-none prettyprint-override"><code>Traceback (most recent call last):
    File "&lt;file&gt;", line 142, in &lt;module&gt;
      print(b.fetchall())
    File "/usr/local/lib/python3.3/dist-packages/mysql/connector/cursor.py", line 676, in fetchall
      raise errors.InterfaceError("No result set to fetch from.")
  mysql.connector.errors.InterfaceError: No result set to fetch from.
  </code></pre>