Copy row as INSERT

[expired user #10895]'s profile image [expired user #10895] posted 7 years ago in General Permalink

I have just switched from Sequel Pro (macOS) and miss the feature to right click on a row in the data view (so a table entry) and copy the row as an INSERT statement to paste it in another's database query editor with the same table schema.

How do you do this in HeidiSQL? In other words: how do I copy entries from one table to another with the same schema?

[expired user #10895]'s profile image [expired user #10895] posted 7 years ago Permalink

Found it. For the records: Use right click > Export grid rows > SQL INSERT... and save the clipboard settings.

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