ExecuteAndImbed to save resultset with the command in the console-pane/log
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 183
Description
When working with databases I often make various requests to help me do my work and for documentation purposes I save the output as a /* */ enclosed cut and paste from the data-pane into the console-pane like
```
SELECT User,COUNT(*) AS Cnt FROM SomeTable WHERE bla bla GROUP BY User ORDER BY Cnt DESC LIMIT 20
/*
John 6364
Claus 8763847
Jane 338271
Mariann 83645348
Peter 0
*/
DELETE FROM SomeTable Where bla bla and User = 'Mariann'
SELECT COUNT(*) FROM AnotherTable WHERE bla bla
/*
6428265456
*/
```
It would be super cool if you could just select the SQL expression and click 'ExecuteAndImbed' and the result whould automatically be /* */ pasted into the console just after the command. To avoid overflowing the console pane an implicit LIMIT 100 could be enforced.
An alternative would be to execute as normal and click "CopyResultAsComment" at the cursor in the console-pane.
A second alternative could be to explicitly copy from table-pane and then click PasteAsComment.
Thanks
Contributor guide
Assessment
This issue has not been assessed yet.