Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Ability to copy a value in the grid along with the column it belongs and formatted for WHERE clause

For example, let's assume this is the output from a query:

id name role

1 Torn ADMIN
2 John CLERK
3 Adam SUPER

I would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.

In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
name = 'Adam' and role = 'SUPER'

16 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Sasha shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Hi,

    Thanks for your patience!

    You can call this from the context menu on the data grid by selecting Generate.

    So we would like to suggest updating to the latest version and check there.

    Best,
    Devart Support Team

  • Anonymous commented  ·   ·  Report

    I'd add another one that is very useful, in your example, if you select the three ID values then it should copy
    (1, 2, 3)
    and possibly
    id IN (1, 2, 3)

    or if you copy the first and second role then it should copy
    ('ADMIN', 'CLERK')
    or even
    role IN ('ADMIN', 'CLERK')

    Toad for MySQL has this feature