List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 20 2000 9:40pm
Subject:Re: Table and Columns Names Storage in Mysql
View as plain text  
At 12:04 PM -0800 03-20-2000, Rajesh Krishna Murthy wrote:
>Hi,
>
>could someone highlight me on the storage of table names and column names
>in mysql like which system tables is it stored. In other words when i
>say >show tables in mysql client from which table does it query and give
>output to me.

There aren't any system tables in MySQL.

show databases simply lists the directories in the data directory
show tables simply lists the *.frm file basenames from the database directory

The column information is stored in the *.frm file for the appropriate table.

-- 
Paul DuBois, paul@stripped
Thread
Table and Columns Names Storage in MysqlRajesh Krishna Murthy20 Mar
Re: Table and Columns Names Storage in Mysqlsasha21 Mar
Re: Table and Columns Names Storage in MysqlPaul DuBois21 Mar
RE: Table and Columns Names Storage in MysqlRajesh Krishna Murthy28 Mar
Re: Table and Columns Names Storage in MysqlThimble Smith28 Mar