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
Result pane to text
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.
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.
Please login to leave a reply, or register at first.