Results SubPanels have incorrect title

aSystemOverload's profile image aSystemOverload posted 5 years 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 years 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 years 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.