Result pane to text
| User, date | Message |
|---|---|
|
Written by cesar_f
8 months 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 jfalch
8 months ago 241 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
8 months ago 457 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
8 months ago 457 posts since Thu, 29 Nov 07 |
Typo: where it says to execute button should say two execute buttons. |
|
Written by cesar_f
8 months 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. |