title: MySQL 'SHOW TABLES' Returns count instead of list (Python)
body: <p>I'm troubleshooting a script I am using to query the database. To make sure I had everything working right I stripped it down to a simple 'SHOW TABLES' query. The problem is that it is returning a count of the tables instead of the list of names it should return. </p>
  
  <pre><code>import pymysql
  
  connection = pymysql.connect(host='10.0.0.208', user='admin', passwd='Passwrd')
  
  cursor = connection.cursor()
  sqlstring = 'SHOW TABLES;'
  cursor.execute('USE CustDB')
  x = cursor.execute(sqlstring)
  
  print(x)
  </code></pre>
  
  <p>This is only returning '17'. What am I missing??</p>