Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

I want to quickly copy and paste records.

mutter21's profile image mutter21 posted 2 months ago in Feature discussion Permalink


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 2 months 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:


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


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

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