It will be much faster to export data if HeidiSQL will automatically assign output filename like @table-name.sql
Please add this feature :)
Automaticly set .sql filename equal to db name
As there is no way to export one table per file, there is no variable for the selected table. Of course you can always select one table, but it does not make sense for the GUI to provide a variable which is invalid as soon as you select a second table, right?
We are talking about the SQL export in the "Table tools" dialog, right? Not the "Export grid rows" dialog, which just exports rows from a table view?
We are talking about the SQL export in the "Table tools" dialog, right? Not the "Export grid rows" dialog, which just exports rows from a table view?
mm, if you right click on table and go to "export database as SQL" it will open dialog with name "Table tools"But thats not the case, maybe it is possible to set table name as default filename while using right click on table, and if clicking on database or if multiple tables are selected - db name as default?!
Yeah, but i need table name, when exporting only one table, not database name :)
Hmmm... I guess was mislead by the question title: Automaticly set .sql filename equal to db name.
If you choose "Output: Directory - one file per object in database subdirectories" you get proper file names automatically, you don't even have to use variables.
Please login to leave a reply, or register at first.