I want to quickly copy and paste records.

mutter21's profile image mutter21 posted 5 years ago in Feature discussion Permalink

Hi,

I am copy and paste records using the "Export grid rows". But it's a bit uncomfortable. Previously in MySQL-Front, selecting a record and pressing Ctrl + C, Ctrl + V would paste the new record. (Similar to Excel.)

So I still use MySQL-Front often. Do you plan to add this feature? If you are worried about the user's mistake, please enable it as an option.

Thank you.

ansgar's profile image ansgar posted 5 years ago Permalink

The grid in HeidiSQL could take only 1 pasted row at a time. Because after posting one row, there is an interaction with the user, if this or that value or many of them are not accepted by the server, or you miss privileges, violating (foreign keys) and so on.

But you could use the quick copy feature, by first assigning the format in the export dialog:

Description

Afterwards, you can use Ctrl-Shift+C to copy selected rows in this predefined format:

Description

... and paste them into a query tab and press F9 to run them.

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