开发者

In Squirrel, how can I duplicate a row?

开发者 https://www.devze.com 2023-04-11 18:43 出处:网络
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

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:

  1. select one row with the context menu entry "Select entire row(s)" or all rows with "Select All"
  2. In the context menu, select "Copy as SQL INSERT-VALUES statement"
  3. Paste the copied content in the sql tab editor

Done

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号