SpringBoot e-commerce project mall (40K + STAR) address: github.com/macrozheng/…

Abstract

When choosing tools, we tend to choose the ones that are free and easy to use! As a paid app, Navicat is powerful, but it doesn’t stop us from exploring new tools. Having recently experimented with MySQL Workbench, the official client tool for MySQL, this article will compare it to Navicat and see if it can replace Navicat!

The installation

Let’s install MySQL Workbench first, there is a small hole that needs to be noticed.

  • First we need to downloadMySQL WorkbenchInstallation package, download address:Dev.mysql.com/downloads/w…

  • Once the download is complete and we double click the installation, we get a problem,MySQL Workbench 8.0Version installation requires installation firstVisual C++ 2019 Redistributable PackageRely on;

  • downloadVisual C++ 2019 Redistributable Package, download address:Support.microsoft.com/en-us/help/…

  • Install after downloadingVisual C++ 2019 Redistributable Package, keep clicking Next;

  • And then double clickMySQL WorkbenchThe installation package, all the way click next to install smoothly.

use

Let’s take a look at the MySQL Workbench with basic database management capabilities.

Making a New connection

Double-click to open MySQL Workbench and enter database connection information to create a new connection.

The appearance Settings

Because the default editor font is small, you can make it larger by using the Edit->Preferences option, but you can only change the font name and size by typing in the Preferences option.

Table management

  • View the database table structure by right-clicking the table to selectTable InspectorTo view;

  • Modify the database table structure by right – clicking table selectionAlter TableTo modify.

Data management

  • View table data and select by right – clicking tableSelect RowsWe can see that the SELECT statement is automatically generated in the SQL editor.

  • To modify the table data, we need to double-click the table field to modify, and then clickApplyTo apply;

  • We can see that the changes in the last tool are converted to UPDATE statements, as you can seeMySQL WorkbenchData operations are eventually converted to statements for execution.

SQL operations

  • We can use the SQL editor to execute SQL statements, using the button in the upper left corner to create an SQL editor;

  • MySQL WorkbenchSQL tips or quite full, to write a SQL try, basic can meet the usual editing SQL needs.

Instance management

  • Check the MySQL service status.

  • Manage MySQL users and permissions;

  • Manage MySQL instance, start and close;

  • View the dashboard that displays performance information about MySQL services.

Contrast Navicat

  • Navicat has a nice database design feature for which I ditched the clunky PowerDesigner, obviouslyMySQL WorkbenchThis feature is not supported.

  • Navicat database design, specific can refer to the database design tool I use handy, this time recommended to everyone! .

  • Navicat has a powerful data backup and structure synchronization function, usually used for data backup, synchronization of the test environment database structure to the production environment is very good, if the MySQL Workbench estimate can only import and export SQL.

  • Use Navicat to implement data backup and structure synchronization. For details, see Navicat Utility Features: Data Backup and Structure synchronization.

  • Instance management features that are unique to MySQL Workbench are not available in Navicat.

  • Navicat supports MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, etc. MySQL Workbench obviously only supports MySQL.

conclusion

Overall, MySQL Workbench is clearly adequate as a MySQL database management tool, but Navicat has many features that it cannot replace. If you want to design a database, have better database operation and maintenance capabilities, or you need to use multiple different databases, use Navicat!

In this paper, making github.com/macrozheng/… Already included, welcome everyone Star!