Number of records in View?

Sorry for the newbie UI question, but...

Query windows show the number of records returned next to the query name (right above the grid) in the form "(69r x 11c)" and the Data window shows something like "150 rows total (exact)" next to the table name (again, above the grid). Does the UI show the number of rows returned by a View? I don't see it. (Instead, I've been using "copy line to new query tab" in the log window and pressing F9 to run the query. Is there a shorter way?

Yes you're right, and I'd say there is definitely missing something.

The reason for the missing row number is the fact that a view does not show an estimated number through SHOW TABLE STATUS:

What I just did to find out the row number quicky: click the "Show all" button (Ctrl Alt End) and look at the left of the very last row (but caution when the table is very large):

Thank you.

Would you be interested in an enhancement if I created a pull request? Not promising…it’s been decades since I programmed in Pascal! (I read somewhere that you only want pull requests for bug fixes.)

Please no pull requests for features or enhancements, only for bugfixes.

I have just added something that now displays the number of view rows in the grid, available in the next nightly build:

Got it.

Thanks for the quick fix.

I'm trialing HeidiSQL after using MySQL Workbench for years...I like your software a lot! Plan to fully switch.

(Though I am having some difficulty SSH tunneling into a MariaDB server. But that may be due to the ancient Linux release on that server or some other non-HeidiSQL issues. I'll continue to troubleshoot that issue. If I conclude that it might be a HeidiSQL issue, I may be back on this forum.)

Feel free to ask! HeidiSQL is good in supporting ancient server software I'd say ;)

The default plink executable started to create new issues over the last releases. So I can recommend to try out the Windows OpenSSH executable there (ssh.exe). Only you need to use a private/public key for authenticating then, as it does not support passwords on the command line.

Thx. I started with ssh.exe and dabbled with key-based authentication without success. But the DB server is so old that I need to supply extra options (ssh -o xxx) when connecting via the command line and I didn't see a way to replicate those command line options in the HeidiSQL UI.

Anyway, I'm trying to get the admin of that server to update some of the relevant packages--I suspect that's the problem. But I'll keep trying. And I'll focus on using ssh.exe and key-based authentication.

If/when I need help, I'll start a new topic.