MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: data import
Posted by: Mike Lischke
Date: October 09, 2014 01:34AM

Hi,

you can only import CSV data, so first export your data to a CSV file. In MySQL Workbench open your connection and run a "select * from yourtable" to create a result set. This is necessary because you can only import data into a result set (or export from there).

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/

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
data import
961
Okty GODOFBINARY
October 05, 2014 02:07PM
Re: data import
616
Mike Lischke
October 09, 2014 01:34AM


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.