Mysql Workbench query mysql database method

Mysql Workbench is an open source database client. This open source software is also quite famous in the IT industry. Many colleagues who use musql like to use this client tool. Today, I will take a look at how to use this tool with you.

First of all, let's start from the beginning. Click Start → Select MySQL Workbench and click to start the application. Of course, you can also choose to enter the program by clicking the desktop shortcut.

Connect to the MySQL console through the previously configured MySQL database link. As shown in the figure below, the editor selects the configured link to enter the MySQL database console

After entering the database console, the database name of the database is displayed next to an oil barrel-like icon at the bottom left of the interface.

Move the mouse over the database and right-click to see some common operations for the database. As shown below

By clicking the expand button next to the database name, you can see a secondary menu called table. Click this table to expand all the data tables under the corresponding database, as shown below

Right-click on the expanded data table to perform some operations on the data table. As shown in the following figure, the editor selects the first select rows limit 1000 to query 1000 data in this table.