List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 27 2002 11:24pm
Subject:Re: FW: Does MySQL provide an access to system tables ? Are there
any ?
View as plain text  
At 16:19 -0700 4/27/02, Vadim wrote:
>Greetings:
>
>I'm a SYBASE DBA and very familiar with Sybase implementation of system
>catalog. (systables; syscolumns, etc) There is a lot of information that
>can be derived from these tables. MySQL, however, doesn't appear to have
>any system tables.

Right, there are none.

>  When use command "describe" it shows the information
>some what similar to what Sybase's set of system tables would produce.
>The question is where does MySQL get this information.

 From the .frm file.

>  Do users have any
>access to it ?

Yes, use the DESCRIBE statement. :-) (Or SHOW COLUMNS, which is synonymous.)

>  Also, can I write to that filed EXTRA (see the example
>below)

No.

>  ? I'm just trying to build a data dictionary based on the info
>MySQL's DESCRIBE command generates. Can anyone suggest a better way to
>create a data dictionary ?
>mysql> describe groupcode;
>
>
>+-------------------+-----------------+--------+--------+-----------+---
>------+
>| Field             | Type            | Null   | Key    | Default   |
>Extra   |
>+-------------------+-----------------+--------+--------+-----------+---
>------+
>| group_code        | varchar(30)     |        | PRI    |           |
>|
>| group_id          | varchar(20)     | YES    | MUL    | NULL      |
>|
>::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
>::::::::::
>
>Thank you very much for your time.
>
>Vadim Kulikov
>877-428-3279
>vadim@stripped

Thread
FW: Does MySQL provide an access to system tables ? Are there any ?Vadim28 Apr
  • Re: FW: Does MySQL provide an access to system tables ? Are thereany ?Paul DuBois28 Apr