Export Result: Single "INSERT INTO"

zeropublix's profile image zeropublix posted 8 years ago in General Permalink

Dear HeidiSQL Team,

would it be possible to have a single "INSERT INTO" Query when exporting results (right-click-action)

Example: NOW: INSERT INTO languages VALUES ('English', 'en', 'icon.gif', 'english', 1); INSERT INTO languages VALUES ('Deutsch', 'de', 'icon.gif', 'german', 2);

Wished result: INSERT INTO languages VALUES ('English', 'en', 'icon.gif', 'english', 1), VALUES ('Deutsch', 'de', 'icon.gif', 'german', 2);

Thanks in advance for every answer

ansgar's profile image ansgar posted 8 years ago Permalink

Just use Tools > Export database as SQL

zeropublix's profile image zeropublix posted 8 years ago Permalink

Just use Tools > Export database as SQL

That would provide me with ALL the values from the Database but i only need specific ones (eg: From 1000 entrys about 300)

ansgar's profile image ansgar posted 8 years ago Permalink

Well, than use the grid export dialog, with the multiple INSERTs. These INSERTs per row are quite reasonable, as you can use these in most other database systems as well. Not so the extended inserts.

[expired user #9489]'s profile image [expired user #9489] posted 8 years ago Permalink

You should also be able to also use the limit clause of your query to filter the rows you want as well

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