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

This article shares Mysql WorkBench installation configuration graphic tutorials for your reference, the specific contents are as follows

workbench download address

Download the workbench download package and follow the default prompts to install it.

If you need to switch between the old and new versions of workbench, you can switch as follows:

workbench connection database

Enter the connection database id, port number, username, and password.

workbench Import and export databases

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

table operation

Enter the table creation statement in the query interface to create a table. Right-click on the established table to truncate, drop and other operations on the table.

table data manipulation

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

The nice thing about Export/Import is that there are many formats:

csv file format, Json format for easy export of test data, SQL INSERT format for easy data migration, Excel format for easy data viewing

Query sql and query display number settings

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

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.