Rows Affected not displaying

HerrimanCoder's profile image HerrimanCoder posted 2 months ago in General Permalink

I'm running HeiSQL 12.7. For a very long time (at least 1-2 years), it doesn't show me the number of rows affected after an update or delete. I could swear it used to do that. When I run a query, I see the resultset just fine. But I never see rows affected after update/delete. I have looked very carefully at the bar at the bottom of the app; it's not there.

Please help.

ansgar's profile image ansgar posted 2 months ago Permalink

I think what you meant to have seen is still there, but in the query execution.

In v12.8, I added some helpful information messages to the log, with a green background color. It's basically what the C API mysql_info returns:

Description

HerrimanCoder's profile image HerrimanCoder posted 2 months ago Permalink

ansgar, I do not understand.

I just downloaded and installed v12.8. I ran the following update query:

UPDATE Users SET Commercial = NULL WHERE ID BETWEEN 1 AND 10

I was hoping to see down in the status bar (or whatever you call that at the very bottom edge of the window) number of rows affected or something similar. But it's not there.

Description

How can I get that to display?

ansgar's profile image ansgar posted 2 months ago Permalink

Did you perhaps disable all of the logging events, in Tools > Preferences > Logging?

grafik.png

HerrimanCoder's profile image HerrimanCoder posted 2 months ago Permalink

Yes, that was the problem. And I do see this now:

Description

But may I respectfully say that the presentation seems cluttery and I don't want to look at all that. I just want to see number of records affected down in the bottom status bar, maybe something like this:

Description

It could be optionally enabled in Preferences. It's a clean, non-cluttered way to show this very important info after each query.

ansgar's profile image ansgar posted 2 months ago Permalink

Well that's the way how HeidiSQL displays such transient information. Note the line order in the log panel helps to tell which was the query prior to that information.

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