Shulou(Shulou.com)06/01 Report--

I. 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, and some operations are more simplified.

First we download workbench

Then select download.

No thanks, just download

After downloading click on default settings until the end of the installation

II. Use of MySQL Workbench

Open Workbench and click local instance mysql on the home page.

Click on this window, this is the workbench workbench workbench

In the main window type mysql command, click the lightning icon can run the command, the results of running the command are in the following results, lightning execution of multiple lines, lightning 1 execution of selected lines

MySQL Workbench Creating Tables

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

Click on the lightning picture to run and view the table. These four tables will be created.

Right-click the database list on the left 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.

MySQL Workbench View relationships between tables

Select Back to Home Page

Select> Select the first option, and then all the way to the end, halfway to see the book database tick

And then you can see the results.

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.