re: how to get all tables

[Egor Egorov]

Huan,
Monday, October 14, 2002, 8:03:36 AM, you wrote:

HH What is the sql command which is the same as command
HH show tables ?

There is no command to see all tables in all databases. You can see
list of tables only for a single database at time.

HH Other database stores all tables in a system table, is there one in mysql ?

No, there are directories per database where MySQL stores tables for
each database.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to get all tables

[Huan He]

Hello,

What is the sql command which is the same as command
show tables ? Other database stores all tables in a
system table, is there one in mysql ?

Thanks,
Tom

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php