Copy row as INSERT

melino posted 12 months ago in General

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?

melino posted 12 months ago

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.