Mysql workbench (database design tool)

Mysql workbench is the official database design modeling tool launched by Mysql. It is the successor of the famous database design tool DBDesigner4. You can use MySQL Workbench to design and create new database diagrams, create database documentation, and perform complex MySQL migrations. MySQL Workbench is the next generation of visual database design and management tools. It has both open source and commercial versions.

Basic introduction

MySQL Workbench provides DBAs and developers with an integrated tool environment that can be used for 1) database design and modeling; 2) SQL development (replacing the original MySQL Query Browser); 3) database management (replacing the original MySQL Administrator)!

How to use

Mysql workbench Chinese language setting method:

edit --> preferences --> appearance --> configure Fonts for : Select Simplified Chinese OK

1) Server Administration
* Use MySQLInstanceConfig to configure MySQL to run as Service;
* Then use New Server Instance of Server Administration of MySQL Workbench to create a new server instance @localhost;
* Use the Data Dump of Server Administration of MySQL Workbench to import our database instance sakila-db. First import sakila schema, and then import sakila data. The import schema is as shown below:

* The imported command line can be seen in the workbench log. The schema is imported as follows:
mysql.exe --defaults-extra-file="c:usersAAAappdatalocaltemptmphjwdop" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "E:mysqlsakila-dbsakila -dbsakila-schema.sql"
The import of data is as follows:
mysql.exe --defaults-extra-file="c:usersAAAappdatalocaltemptmpbsop_e" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "E:mysqlsakila-dbsakila -dbsakila-data.sql"
* At the same time, you can also use the Data Dump of Server Administration of MySQL Workbench to export the database. There are two export formats. The first is to export to the dump project folder, each table is a sql file, and the second is to export as a self contained file. All tables are exported as a sql file;
2) SQL Development
* Use the new connection of SQL Development of MySQL Workbench to create a link localhost and link to the previously imported database instance sakila, as follows:

* Query the actor table contents of the database instance sakila in the SQL Development environment of MySQL Workbench, as follows:

3)Data Modeling
* Use the open existing EER model of MySQL Workbench's Data Modeling to open the sakila.mwb file in the database instance sakila, as shown below:

​

* Usually, we use MySQL Workbench's Data Modeling to design the database starting from modeling. After the modeling is completed, export it to a sql statement, and then import the sql into the database to complete the creation of the database;