MySQL Forums
Forum List  »  MySQL Workbench

Re: I don't have a Query drop down in MySQL Workbench
Posted by: Mike Lischke
Date: September 10, 2013 01:49AM

Luis,

it seems you are confusing modeling and SQL work. Reverse engineering an SQL script to create a model is an action to allow designing a schema and its objects. It doesn't use nor manipulate any data in those objects (not even keep it). Modeling is all about meta data, it's a design tool.

In order to get the objects and their data into a real server you have to import it. You can use the Backup/Restore tool if this is a bigger set of data (or many scripts) or simply run the script you got in an SQL editor. Once that succeeded you can then simply run usual queries like "SELECT * FROM <yourtable>".

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: I don't have a Query drop down in MySQL Workbench
649
September 10, 2013 01:49AM


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.