In MySQL Workbench, is there a page showing the number of records in each table in a database?

Question

In phpMyAdmin, on the Structure page for each database, there is a table showing all the tables in the DB and the number of records in each table. Is there something similar in Workbech?

Thanks.

Answer 1

Late answer but for anyone else who comes across this page the way to do this in MySQL Workbench 6.0 is:

1. Right click the table in the Navigator pane
2. Select "Table Maintenance..."
3. Navigate to the "Indexes" tab
4. Scroll to the right to find the "Cardinality" column.

This column shows you the number of values for each of the primary and navigation keys in the each table in your database. The number of values for your PRIMARY key is the number of rows. Hope that helps.

Another way is to:

1. Right-click the database in the Navigator pane.
2. Select "Schema Inspector".
3. Navigate to the "Tables" tab, which will have a "Rows" column for each table in the database.

Answer 2

I dont know how to do it in MySQL Workbench but the following query returns the number of rows in a table.

SELECT COUNT(*) FROM table_name;