Bug #40326 Help for --count in mysqlshow fails to mention column counts
Submitted: 25 Oct 2008 10:56 Modified: 8 Feb 2009 18:28
Reporter: Janek Bogucki Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.0.51a, 5.1.31 OS:Linux (Ubuntu 8.04)
Assigned to: CPU Architecture:Any
Tags: Help, mysqlshow
Triage: Needs Triage: D4 (Minor)

[25 Oct 2008 10:56] Janek Bogucki
Description:
The --count shows counts for each table of

  columns
  rows

but the help text (mysqlshow --help) only mentions the row count,

  --count             Show number of rows per table (may be slow for not MyISAM
                      tables)

How to repeat:
Read the output of mysqlshow --help and compare it with this,

$ mysqlshow -uroot -p mysql --count
Enter password:
Database: mysql
+---------------------------+----------+------------+
|          Tables           | Columns  | Total Rows |
+---------------------------+----------+------------+
| columns_priv              |        7 |          0 |
| db                        |       20 |          7 |
| func                      |        4 |          0 |
| help_category             |        4 |         37 |
| help_keyword              |        2 |        403 |
| help_relation             |        2 |        830 |
| help_topic                |        6 |        477 |
| host                      |       19 |          0 |
| proc                      |       16 |         38 |
| procs_priv                |        8 |          6 |
| tables_priv               |        8 |          1 |
| time_zone                 |        2 |          0 |
| time_zone_leap_second     |        2 |          0 |
| time_zone_name            |        2 |          0 |
| time_zone_transition      |        3 |          0 |
| time_zone_transition_type |        5 |          0 |
| user                      |       37 |          6 |
| user_info                 |        6 |          0 |
+---------------------------+----------+------------+
18 rows in set.