MySQL Lists are EOL. Please join:

List:Internals« Previous MessageNext Message »
From:Markus Grundmann Date:June 8 2001 1:13pm
Subject:Re: Re: mysqlshow.c - Modifications - 2nd Try
View as plain text  

Two additional columns view more database/table details.

Example:

TRINITRON# mysqlshow <-- show all databases
+---------------+--------+------------+
|   Databases   | Tables | Total Rows |
+---------------+--------+------------+
| activezone    |     18 |       4727 |
| bennini       |      - |          - |
| clientstats   |      3 |          1 |
| collin        |      - |          - |
| domains       |      1 |         21 |
| em2000        |      5 |       1108 |
| foerster      |      - |          - |
+---------------+--------+------------+

.. and ..

TRINITRON# mysqlshow activezone   <-- Show details of "activezone"
Database: activezone
+-------------+------------+
|   Tables    | Total Rows |
+-------------+------------+
| access      |       2719 |
| dnsentries  |          0 |
| downloads   |        615 |
| links       |         78 |
| member      |          8 |
| news        |         39 |
| nolog       |          4 |
+-------------+------------+

Best Regards

Markus Grundmann
http://activezone.org

Thread
Re: Re: mysqlshow.c - Modifications - 2nd TryMarkus Grundmann8 Jun
  • Re: mysqlshow.c - Modifications - 2nd TryAntony T Curtis8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryJeremy Zawodny8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryRussell E Glaue8 Jun
      • Re: mysqlshow.c - Modifications - 2nd TryMichael Widenius11 Jun
  • Re: mysqlshow.c - Modifications - 2nd TryClaes MÃ¥nsson8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryRussell E Glaue8 Jun
    • Re: mysqlshow.c - Modifications - 2nd TryPaul DuBois8 Jun
  • Re: mysqlshow.c - Modifications - 2nd TryAntony T Curtis8 Jun
  • Re: mysqlshow.c - Modifications - 2nd TryClaes MÃ¥nsson8 Jun
  • Re: mysqlshow.c - Modifications - 2nd TrySinisa Milivojevic9 Jun