I just updated to SQLyog 10.2 to find that I could no longer export a result set to SQL. I then found this in the changelog for 10.12:
Quote:
Also ‘Export table as .. SQL’ has now been disabled for multi-table result sets. This is an old issue, but exporting data from multiple tables to SQL never made sense.
Maybe it did not make sense to you, but I use this feature frequently.
For example, I have read-only access to some database. I want to do some data processing but it involves bringing together frequently updated data from multiple tables, so I do a handful of joins and filtering and I end up with the result set that I want. Now I want to transfer those results to a local database where I have more permissions, smaller data sets (faster queries), and I don't have to worry about the performance impact of my queries on the server. I may take a table with hundreds of millions of rows, select only a million of them, join in other information, and then export, for example.
SQLyog used to enable this for me, but now it's broken.
I can't imagine how you think exporting the data to CSV, HTML and XML are all useful in this scenario, but somehow SQL is not, given that I am using a SQL front-end to process SQL queries on SQL databases?
Please restore this functionality.
