At 12:04 PM -0800 03-20-2000, Rajesh Krishna Murthy wrote:
>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