MySQL Workbench

The official version of MySQL Workbench is an ER/database modeling tool specially designed for MySQL. It is the successor of the famous database design tool DBDesigner4. You can use the latest version of MySQL Workbench to design and create new database diagrams, create database documents, and perform complex MySQL migrations. Friends who like MySQL Workbench, come to Huajun Software Park to download and experience it!

Basic introduction to MySQL Workbench

Mysql workbench provides DBAs and developers with an integrated tool environment that can be used for database design and modeling, SQL development (replacing the original MySQL Query Browser), and database management (replacing the original MySQL Administrator)!

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.

MySQL Workbench Features

1. Development

MySQL Workbench provides visual tools for creating, executing, and optimizing SQL queries. The SQL editor provides color syntax highlighting, reuse of SQL fragments and SQL execution history. The Database Connection Panel enables developers to easily manage database connections. The Object Browser provides instant access to database schemas and objects.

2. Management

​​​Provides a visual console to easily manage your MySQL environment and better understand your database. Developers and DBAs can use visual tools to configure servers, manage users and view database health.

3. Design

​​​​Enables DBAs, developers or data architects to visually design, model, build and manage databases. It includes everything a data modeler needs to create complex ER models, forward and reverse engineering, and also provides key functionality to perform difficult change management and documentation tasks that often require significant time and effort.

4. Database migration

MySQL Workbench now provides a complete, easy-to-use solution for migrating Microsoft SQL Server, Sybase ASE, PostreSQL and other RDBMS tables, objects and data to MySQL. Developers and DBAs can quickly and easily convert existing applications to run on MySQL on Windows and other platforms. Migration also supports migrating from earlier versions of MySQL to the latest version.

MySQL Workbench installation steps

​​ 1. Download the compressed package of the official version of Mysql workbench from Huajun Software Park, unzip it, double-click to run the program, the software installation wizard will pop up, click "Next" to start the installation;

​​ 2. Customize the software installation path. The default installation path is "C:Program FilesMySQLMySQL Workbench 8.0 CE". It is recommended that you install it on the D drive, but do not choose a path with Chinese symbols when selecting. Click "Next" to install;

3. Select the installation type that best suits your needs. By default, we select the first option "Complete" for complete installation;

4. By default, click "Install" to install and wait for the installation progress to be completed.

5. The software is being installed, we are waiting patiently

​​ 6. The software is installed successfully, click finish;

How to use MySQL Workbench

How to create a database in MySQL Workbench?

Right-click in the blank space of the SCHEMAS list and select "Create Schema..." to create a database, as shown in the figure below.

In the dialog box to create a database, enter the name of the database in the Name box, and select the character set specified by the database in the Collation drop-down list. Click the Apply button to create it successfully, as shown in the figure below.

After completing the settings in the database creation dialog box, you can preview the SQL script of the current operation, that is, CREATE DATABASE test_db, then click the Apply button, and finally click the Finish button directly in the next pop-up dialog box to complete the database test_db Create as shown below.

Use the same method to create the database test_db_char, and the specified character set defaults to UTF-8.

MySQL Workbench FAQ

How to set the auto-increment ID in the official version of MySQL Workbench?

Method 1: SQL syntax

Method 2: Graphical interface method

How to add default values ​​to fields in the official version of MySQL Workbench?

Method 1: SQL syntax

Method 2: Graphical interface method

MySQL Workbench update log

Working day and night just so you can be happier

                                                                                                                                    are all gone!