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.

Table Lablel for Export Substitution

landreww's profile image landreww posted 3 years ago in Feature discussion Permalink

It appears that among the useful substitution labels for export filenames, I cannot find a table name option. It would logically be %table but it is not there. Is it there under a different label?

ansgar's profile image ansgar posted 3 years ago Permalink

No, the table name is not in the replacements list. See attached image for a complete list.

At least in the SQL export there is no point in using the table name in the file name. The only output option suitable for getting table names is the "Directory, one file per object in database subdirectories".

I'm not sure if you're talking about that dialog, or the other export dialog, which just exports one table. In the latter case it would make sense to add a table name replacement.

1 attachment(s):
  • export-replacements
landreww's profile image landreww posted 3 years ago Permalink

I understand that when exporting several tables or an entire database it would not make any sense to have a table name. However, I export single files on a regular basis. I must copy and paste the table name for each export. It would be very helpful the table name could be in a replacement variable (see image).

1 attachment(s):
  • tablename

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