Mysql WorkBench installation and configuration graphic tutorial

This article shares with you the installation and configuration of Mysql WorkBench graphic tutorial for your reference. The specific content is as follows

Workbench Download Address

After downloading the workbench download package, follow the default prompts to install it.

If you need to switch between the old and new versions of the workbench, you can follow the instructions below:

Workbench connects to database

Enter the database connection ID, port number, user name and password.

Workbench import and export database

Realize the import and export of library table structure and data.

Table Operations

Enter the table creation statement in the query interface to create a table. Right-click on the created table to perform operations such as truncate and drop on the table.

Data Operations in Tables

Select the red circle to add data, select the blue circle to delete data. Of course, you can directly select the data part, right-click delete Rows or copy Rows, and then click Apply.

The good thing about exporting/importing data is that there are many formats:

csv file format, Json format is convenient for exporting test data, SQL INSERT format is convenient for data migration, Excel format is convenient for data viewing

Query SQL and query display number settings

You can save the executed SQL statements in a file to facilitate subsequent opening of queries. Select the query statement and click the lightning symbol to run it. The number of displayed items can be set by limiting the number of items.

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.