MySQL Workbench download and use tutorial detailed explanation

1. Download MySQL Workbench

Workbench is a graphical management tool for MySQL. You can enter MySQL statements in Workbench, which may be more suitable for most people's vision. Some operations can be simplified.

First we download the workbench

Then select download

Select no thanks, just download

After downloading, click the default settings and keep clicking next until the installation is complete.

2. Use of MySQL Workbench

Open Workbench and click local instance mysql on the home page

After clicking, this window appears. This is the workbench workbench

Type the mysql command in the main window and click the lightning icon to run the command. The result of running the command is in the results below. Lightning executes multiple lines, and Lightning 1 executes the selected line.

3. Create a table in MySQL Workbench

First create database book; then create 4 tables under book database

Click on the lightning image to run and view the table. These four tables are created.

Right-click the database list on the left and select refresh to refresh, and you can see the visual table. Right-click and select alter, drop to modify and delete the table. You can try it manually.

4. MySQL Workbench to view the relationship between tables

Select Back to Home Page

Select > Select the first option, then click Next all the way to the end, and see the book database check mark halfway

Then you can see the results

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.