MySQL Forums
Forum List  »  MySQL Workbench

Re: Workbench create database
Posted by: Mike Lischke
Date: December 03, 2009 01:49AM

With WB you have actually 3 possibilities to do that. One is, as you guessed, using plain SQL code, just as you would do on the command line. This might be the fastest one, depending on your skill level. Also using an SQL script file containing all the definitions you need will help a lot (you can execute this in WB).

The other two options are rather graphically oriented. That means you can use wizards and property editors to do what you want. If you create a model in the WB model designer you can later either sync this to your database or let it create a script which can be executed to create all the objects. This is probably the best way if you have to do that frequently or want to strictly follow a design<->creation pattern.

For ad hoc creations you can simply do that in the SQL IDE. There is an overview tab in the lower part, which lists all your schemata. Click the "+" button to create a new schema. Double click its tab to edit some properties of it. Then use the "Add Table", "Add View" and "Add Routine" to create new objects therein.

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
70276
December 02, 2009 09:20PM
Re: Workbench create database
33261
December 03, 2009 01:49AM
17419
January 05, 2010 10:55AM
15226
January 11, 2010 02:02AM
11306
February 03, 2010 02:57PM


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.