MySQL View Table Counts

Escondido's profile image Escondido posted 1 year ago in Feature discussion Permalink

Is there a way to view the row count for specific mysql views when clicking on the Database? I saw a post from many years ago about it, but I don't see a way to do it.

It would be great if I could multi-select views, right click and run, "select count(*) AS 'row_count' from mysqlviewnamehere. Like you can do with phpmyadmin.

ansgar's profile image ansgar posted 1 year ago Permalink

Not in the database tab. You can of course fire that in a query tab.

roshin_philip2's profile image roshin_philip2 posted 1 year ago Permalink

you can get the row count for specific MySQL views by executing a SQL query in your MySQL client or through a programming language that supports MySQL connections. Here's an example SQL query that you can use to get the row count for a specific MySQL view:

SELECT COUNT(*) AS row_count FROM mysqlviewnamehere;

You can execute this query by connecting to your MySQL server and running it in a query editor or command line interface.

Alternatively, you can use a tool like phpMyAdmin to get the row count for multiple MySQL views at once. In phpMyAdmin, you can select multiple views, right-click on them, and then choose "Check table" from the context menu. This will display the row count for each selected view.

Please login to leave a reply, or register at first.