Result pane to text

cesar_f posted 2 years ago in Running SQL scripts
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?

jfalch posted 2 years ago
Use the mysqldump tool instead, or the mysql.exe command line client ? both of these create text files that can be concatenated easily.
kalvaro posted 2 years ago
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.
kalvaro posted 2 years ago
Typo: where it says to execute button should say two execute buttons.
cesar_f posted 2 years ago
thx guys, i'll test suggestions and report feedback for future reference.

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