MySQL Forums
Forum List  »  MySQL Workbench

Re: Database but no data?
Posted by: Mike Lischke
Date: May 20, 2015 01:01AM

Trafford,

so far you missed an essential piece in the picture: MySQL Workbench is 2 tools in one:

1) A modeling part, for designing your database.
2) The SQL IDE for working with your database(s) and managing your server(s).

The "Inserts" tab in the table editor in modeling is a special area to take some test data that is applied when synchronizing your model. It is not meant to keep a large amount of data. Modeling is about design and that should be done before you fill in your data, as applying design changes can easily lead to data loss (e.g. when dropping a column).

What you really want is the SQL IDE, where you connect to your server and work with your data. You can import CSV data into a table (see context menu in the schema tree) and other work. There are overlay icons in the schema sidebar on the left that allow quick access to table data, table editor and table info (respectively the other db objects).

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
1665
April 26, 2015 06:14PM
419
April 26, 2015 06:17PM
528
April 27, 2015 02:40PM
377
April 28, 2015 01:21PM
467
April 28, 2015 08:43PM
489
April 28, 2015 10:14PM
629
May 16, 2015 02:16PM
430
May 16, 2015 03:40PM
Re: Database but no data?
493
May 20, 2015 01:01AM


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.