MySQL Bugs: #5338: drag & drop to sql window does mind object type

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:	None
Category:	MySQL Query Browser	Severity:	S4 (Feature request)
Version:	1.0.7	OS:	Windows (WinXP SP1)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
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

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.

Many thanks for writing a feature request. I will close this request now, because Query Browser functionality will be implemented in Workbench in future.