In Squirrel, how can I duplicate a row?
In a tool like SQL Developer, I can right click on a row and select duplicate to get a copy of row, edit it, and commit it. How can I do this in Squirrel? I don't even see how to add a new row in the Conten开发者_StackOverflowt view.
Found a way to insert rows, though not duplicate. In the Content view, right-click and choose "Make editable" (I thought this just applied to the selected row). Right-click again and now there is an "Insert Row" option. A popup appears for entering the values for each field of the new row.
It is possible to duplicate. You have to do following:
- select one row with the context menu entry "Select entire row(s)" or all rows with "Select All"
- In the context menu, select "Copy as SQL INSERT-VALUES statement"
- Paste the copied content in the sql tab editor
Done
精彩评论