Re: Viewing the DB
| From: | Ashley M. Kirchner | Date: | Wed, 24 Jan 2001 15:45:29 +0000 |
| Subject: | Re: Viewing the DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6134@lists.php.net to get a copy of this message | ||
Scott Fletcher wrote:
> Does anyone know what is the sql command that would allow me to view all of
> the tables in the database?
In MySQL:
mysql> show tables;
+-----------------+
| Tables in mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
AMK4
--
H | Hi, I'm currently out of my mind. Please leave a message. BEEEEP!
|____________________________________________________________________
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ashley M. Kirchner <mailto:ashley@pcraft.com> .
303.442.6410 x130
Director of Internet Operations / SysAdmin . 800.441.3873 x130
Photo Craft Laboratories, Inc. . eFax 248.671.0909
http://www.pcraft.com . 3550 Arapahoe
Ave, #6
.................. . . . . Boulder, CO 80303, U.S.A.