Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #41689

Re: MySQL database schema discovery

Show all headers | View raw

On 22/03/2013 16:01, Roy Smith wrote:
> What are my options for MySQL schema discovery?  I want to be able to
> find all the tables in a database, and discover the names and types of
> each column (i.e. the standard schema discovery stuff).
> 
> PEP 249 doesn't seem to have any discovery methods.  Nor does MySQLdb
> appear to have any non-standard extentions for this.  I could probably
> do this with SQLAlchemy, but I'm trying to avoid that because it's so
> heavyweight.
> 

MySQL appears to support the standard(ish) INFORMATION_SCHEMA schema:

  http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

TJG

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

MySQL database schema discovery roy@panix.com (Roy Smith) - 2013-03-22 12:01 -0400
  Re: MySQL database schema discovery Tim Golden <mail@timgolden.me.uk> - 2013-03-22 16:09 +0000

csiph-web