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.

Allow naming of table in Export Grid rows

Acs's profile image Acs posted 6 years ago in Feature discussion Permalink
Hey,

I would like to know if it is possible to add the option to give a name to when you are exporting the grid rows from an inner join query. Right now when I export as sql inserts I get this:

INSERT INTO `UnknownTable` (`field_id`, `field_team`) VALUES (1, 2);

This might not seem like a big deal but the data I am exporting is over 250K rows. So I now have to use some other program to go in and replace the UnknownTable with the table name I want. (I am currently using Notepad++ but it seems to fail, it adds CRLF in some lines without reason)

NOTE: I am exporting from an inner join query because I need to pass data from one database to another. These databases have similar structure and that is why I can't export directly from the table.
ansgar's profile image ansgar posted 6 years ago Permalink
Understand. But I think the dialog already has enough controls. Adding even more would frustrate newbies.
Acs's profile image Acs posted 6 years ago Permalink
If you design it properly it won't matter and besides the option to name the table only needs to be there if the name is UnknownTable.

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




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.