Re: How to save query results
Martins,
with that command you just duplicate the table. Isn't it obvious that this has nothing to do with exporting a dataset?
The server doesn't know anything about clients accessing it. So anything you do directly in the server (like running queries) happens just there, without any involvement of a client.
Instead run a select on the table you wanna export and in the result set tab you can use the export button in the toolbar to create an excel sheet from it.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/
Subject
Views
Written By
Posted
1231
October 29, 2015 01:54PM
Re: How to save query results
589
November 02, 2015 02:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.