[Zope-DB] Accessing the MySQL data dictionary

Ken Winter ken at sunward.org
Wed Jun 1 16:50:49 EDT 2005

I couldn't try the nicest way, because I don't know the names of the data
dictionary tables & columns.  

Also, I'm not sure if a SQL SELECT would reference them in the same way as
one references an ordinary data table.  E.g. if the MySQL meta-table that
stores all the user-defined tables were named "all_tables", would the SELECT
statement be simply: "SELECT * FROM all_tables"?  Or is some sort of prefix
or modifier or something needed to denote these special tables?

Any help on these names and references?

- Ken

> -----Original Message-----
> From: Dieter Maurer [mailto:dieter at handshake.de]
> Sent: Wednesday, June 01, 2005 4:30 PM
> To: ken at sunward.org
> Cc: zope-db at zope.org
> Subject: Re: [Zope-DB] Accessing the MySQL data dictionary
> Ken Winter wrote at 2005-5-31 21:21 -0400:
> > ...
> >The nicest way would be to just do SQL SELECTs against the data
> dictionary
> >tables.
> What happened when you tried the nicest way? ;-)
> --
> Dieter

More information about the Zope-DB mailing list