Result pane to text

hi,
I've 15+ years experience in MSSQL but I'm a rookie in MySQL.
In MSSQL is very easy to create very complex text output just changing results pane from grid to text.

I need to create a custom db dump because of FKs and other things, so I'm quering INFORMATION_SCHEMA, etc... but I don't know how to get one text instead a lot of resultsets

Is this possible in HeidiSQL or other tool you know?

br

Use the mysqldump tool instead, or the mysql.exe command line client ? both of these create text files that can be concatenated easily.

Oracle SQL Developer has a similar feature: there're two result panes (grid and text) and you have to "execute" button to chose where to execute the query.

HeidiSQL's equivalent is to launch the query as usual, right click on the grid and select "Export grid rows". You can copy to clipboard and there're many formats to choose from.

Typo: where it says to execute button should say two execute buttons.

thx guys, i'll test suggestions and report feedback for future reference.