Bug #5338 drag & drop to sql window does mind object type
Submitted: 1 Sep 2004 10:08 Modified: 15 Dec 2008 12:34
Reporter: Andreas Götz Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Query Browser Severity:S4 (Feature request)
Version:1.0.7 OS:Windows (WinXP SP1)
Assigned to: Michael G. Zinner CPU Architecture:Any

[1 Sep 2004 10:08] Andreas Götz
using drap&drop of tables and columns to sql window is very nice but should offer different options depending on object type, e.g. dragging a column might build a where or join clause, while dragging a table might offer a union etc.

How to repeat:
drag table vs. drag column
[1 Sep 2004 10:59] Michael G. Zinner
Only tables should be dragged. To add columns to the different clauses of a SELECT, press [Alt GR]+[S] (=SELECT clause), [Alt GR]+[W] (=WHERE clause), [Alt GR]+[O] (=ORDER BY) and then simply click on a column to add it.

Instead of pressing [Alt GR] or [Ctrl]+[Alt] one can also select the appropriate mouse cursor with the round buttons. But that is way slower and only for learning the functionality.

We though it's better to add columns to the command by a keyboarc shortcut + simple click, since that saves the time when addin a lot of columns.

That information should already be available in the Help ("Building Queries Visually") and I will also overwork the Quick Start Guide (also see the Help menu), that is displayed the first time the application is started after a clean install (with no useroptions present).

But it might be a good idea to also allow dragging of columns. We have to discuss this internally.
[15 Dec 2008 12:34] Susanne Ebrecht
Many thanks for writing a feature request. I will close this request now, because Query Browser functionality will be implemented in Workbench in future.