#22 SQL Shortcuts

General
closed
Gerd Wagner
General (118)
5
2008-04-16
2002-07-04
Jean van Wyk
No

A very nice feature which I picked up from DbVisualizer
is the concepts of shortcuts. (I am not sure that
"shortcuts" is what they call it.)

What basically happens is that when one clicks on the
content tab of a table or view (and see the data in the
table) one can right click and get options like Select
all, Select count, Select, Delete, Insert, Update,

Say I chose the first three columns of a row in a table
and select Delete. It will then take me to the SQL
section, where a delete from table_name, where ...
clause will have been pasted with the thee columns
names and pre-populated values.

Discussion

  • Colin Bell
    Colin Bell
    2002-09-20

    • assigned_to: nobody --> colbell
     
  • Colin Bell
    Colin Bell
    2004-07-15

    • assigned_to: colbell --> gerdwagner
     
  • Colin Bell
    Colin Bell
    2004-07-15

    Logged In: YES
    user_id=233132

    Hi Gerd,

    I'm assigning this to you as I think it would be a nice
    addition to the Scripts plugin. Flick it back to me if you
    don't agree.

    Col

     
  • Gerd Wagner
    Gerd Wagner
    2008-04-16

    • status: open --> closed
     
  • Gerd Wagner
    Gerd Wagner
    2008-04-16

    Logged In: YES
    user_id=776065
    Originator: NO

    Is rather well covered by the "Copy as SQL WHERE / UPDATE-SET statement" function in tables.
    Will be closed.