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.

Results SubPanels have incorrect title

aSystemOverload's profile image aSystemOverload posted 5 months ago in General Permalink

When you write multiple statements within the query window, such as:

select from customer select from orders select * from products

you get multiple sub-panes in the results pane, which is great. but for the above, they would all say "customer NxN", rather than the first saying "customer", "orders", "products".

aSystemOverload's profile image aSystemOverload posted 5 months ago Permalink

Sorry, try again... When you write multiple statements within the query window, such as:

select * from customer

select * from orders

select * from products

you get multiple sub-panes in the results pane, which is great. but for the above, they would all say "customer NxN", rather than the first saying "customer", "orders", "products".

ansgar's profile image ansgar posted 5 months ago Permalink

This is only the case when you do not separate the queries with a semicolon. HeidiSQL is not able to detect these as 3 separate queries. The fact that you get 3 results is a feature of the SQL server.

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