Copy selected rows to another table

dafi's profile image dafi posted 2 years ago in General Permalink

I'm must be missing something here... I want to copy one or more rows from one table to another table (same format). Actually the second table is the same table in a second copy of the database.

I can select the row and then right click to get "Copy selected rows" but I can't figure how to paste into the other table. If I use Control V it just pastes into one cell.

hrvoj3e's profile image hrvoj3e posted 2 years ago Permalink

I just use "Export grid rows" > "Output format = SQL REPLACEs" and run the generated queries myself.

dafi's profile image dafi posted 2 years ago Permalink

Yes I worked that out but I figure as there is an option to copy selected rows, there must also be a way to paste them! I little more direct than pasting into a query tab.

ansgar's profile image ansgar posted 2 years ago Permalink

No, there is only the way to paste and run the copied stuff in a query editor.

dafi's profile image dafi posted 2 years ago Permalink

Thanks for the answer Ansgar. A possible new feature perhaps? I find I need to use it when I add a row or rows to my test database and then want to copy them into my production database.

RevitArkitek's profile image RevitArkitek posted 1 month ago Permalink

Is this still on the wish list? A feature I would like to see is the ability to transfer rows older than a certain date (from Date column) to another table for archiving purposes.

ansgar's profile image ansgar posted 4 weeks ago Permalink

No, there is no such a feature request in the tracker as far as I recall. But there are 290 open issues, so feel free to search for it.

I understand the request, especially because the GUI allows to read by "Copy selected rows", without the ability to write the same thing back by some "Paste copied rows" action. Problem is that this "Copy selected rows" is highly customizable, in the "Export grid rows" dialog. The button "Save clipboard settings" stores the settings for clicks on "Copy selected rows". But this was never meant to get imported by one click again. It's more for external programs, or probably Heidi's query editor, if you export SQL INSERTs or so. I don't think it's worth writing a parser for all that stuff you can export. For pasting rows, there must be one specific format defined for the clipboard, which we don't have currently.

Please login to leave a reply, or register at first.