Listing tables

MySQL database connector for Python programming

Brought to you by: adustman

Listing tables

Forum: Help

Creator: Thomas Robitaille

Created: 2009-06-24

Updated: 2012-09-19

Thomas Robitaille - 2009-06-24

Hi,

I'm trying to get a list of all the tables in a database. I tried using 'show tables', but the result is just a long integer:

In [4]: cursor.execute('show tables')
Out[4]: 7L

Is there an easy way to get a full list of the tables in a given database?

Thanks,

Thomas

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Thomas Robitaille - 2009-06-24
  
  I figured it out eventually, I needed to do
  
  cursor.execute('show tables;')
  for (table_name,) in cursor:
  print table_name
  
  Thomas
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.