MySQL Workbench – How to Use Query Tabs

mysql-workbench

I am trying MySQL Workbench 6.0 and when I execute a query the results are displayed with a tab called "Result 1". When I fire another query the same tab is reused, now named "Results 2".

I found no way to open a new results tab (not query tab). What am I missing?

Best Answer

MySQL Workbench always closes all existing resultset tabs when it executes the content in a specific tab. If you have several queries in your editor and execute all of them (and they return a result set) then a new resultset tab is created for each returned set.

If you want a specific resultset tab to stay while running other queries open it in a separate editor tab.

Related Solutions

MySQL Workbench Error – Creating Foreign Key Issue

You will get this message if you're trying to add a constraint with a name that's already used somewhere else.

According to this post you can check your constraint like this:

If the table you're trying to create includes a foreign key constraint, and you've provided your own name for that constraint, remember that it must be unique within the database. Run this query to see if that name is in use somewhere:

SELECT
  constraint_name,
  table_name
FROM
  information_schema.table_constraints
WHERE
  constraint_type = 'FOREIGN KEY'
  AND table_schema = DATABASE()
ORDER BY
  constraint_name;

MySQL Workbench is not finding MySQL service

I custom named the Windows service

This may seem a bit of an obvious question... but have you considered not doing that?

Best Answer

Related Solutions

MySQL Workbench Error – Creating Foreign Key Issue

MySQL Workbench is not finding MySQL service

Related Question