distal-attribute
distal-attribute
distal-attribute
distal-attribute

Result pane to text

User, date Message
Written by cesar_f
2 years ago
Category: Running SQL scripts
2 posts since Thu, 04 Oct 12
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
Written by jfalchMoney, Euro
2 years ago
388 posts since Sat, 17 Oct 09
Use the mysqldump tool instead, or the mysql.exe command line client ? both of these create text files that can be concatenated easily.
Written by kalvaro
2 years ago
594 posts since Thu, 29 Nov 07
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.
Written by kalvaro
2 years ago
594 posts since Thu, 29 Nov 07
Typo: where it says to execute button should say two execute buttons.
Written by cesar_f
2 years ago
2 posts since Thu, 04 Oct 12
thx guys, i'll test suggestions and report feedback for future reference.
 

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