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.

Copy Query Results in Text Format

John Bell's profile image John Bell posted 4 months ago in General Permalink

if i run a query to generate a list of commands (drop table ...). it would be nice to have a straight text export option as copy only seems to work with one row. This way i could copy to clipboard and paste into your query editor without fooling around with csv options. If i have missed something then i apologize in advance. Thanks.

ansgar's profile image ansgar posted 4 months ago Permalink

Well, no problem:

  • rightclick any result and click "Export grid rows"
  • select "Delimited text" and set the options you like
  • press the "Save clipboard settings"
  • leave the dialog via cancel button
  • from now on, use the "Copy as" rightclick menu and its "Delimited text" item for copying rows in your preferred format

Description

John Bell's profile image John Bell posted 4 months ago Permalink

I guess i wasn't clear. i know you can do it by adjusting the delimited text options (and it isn't that difficult) but was hoping for a text only option in the copy as menu. Thanks for the fast response.

ansgar's profile image ansgar posted 4 months ago Permalink

Then what would be the difference between your "text only" and "delimited text" format? There's not much, is it?

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.