Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Minor suggestions

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

I started using HeidiSQL a few months ago and I enjoy it.

I have some minor suggestions to make. If I run a query like "SELECT COUNT(*) FROM table WHERE value = 'one & two';" and then I place the mouse over the tab, the ampersand is displayed incorrectly like _ (probably it should be doubled like && to be displayed correctly).

I often comment multiple lines of queries with a # at the beginning of the line, because I don't want to lose them and I uncomment them as I need. After I run all uncommented queries, the mouse over query tabs shows all the commented queries from above as well as the valid query. Is there a way to display just the relevant query? I suggest for example not to display the lines that start with # and display the comments that are in between / ... /

Thanks, Nick

NickF's profile image NickF posted 2 months ago Permalink

I started using HeidiSQL a few months ago and I enjoy it.

I have some minor suggestions to make. If I run a query like "SELECT COUNT(*) FROM table WHERE value = 'one & two';" and then I place the mouse over the tab, the ampersand is displayed incorrectly like _ (probably it should be doubled like && to be displayed correctly).

I often comment multiple lines of queries with a # at the beginning of the line, because I don't want to lose them and I uncomment them as I need. After I run all uncommented queries, the mouse over query tabs shows all the commented queries from above as well as the valid query. Is there a way to display just the relevant query? I suggest for example not to display the lines that start with # and display the comments that start with a slash followed by asterisk and end with an asterisk followed by slash.

Thanks, Nick

ansgar's profile image ansgar posted 2 months ago Permalink

Comments are parsed away on the server-side, not by HeidiSQL. This is why they still are part of an executed query, and why they are displayed in the balloon hint over result tabs. There's no practical and stable way of removing them before you run it.

I can instead recommend to use the "Run current query", when the cursor is on the one you want to fire:

Description

This way you don't need to comment out queries above or below.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.