Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to use Workbench to query mysql database. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

First of all, start → by clicking on the computer, select Mysql Workbench, and click to start the application. Of course, the viewer can also choose to enter the program by clicking on the desktop shortcut.

Connect to the mysql console through the previously configured mysql database link. As shown in the following figure, 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 displayed at the bottom left of the interface.

Move the mouse over the database, and then right click, you can see some common operations for the database. The figure below is as follows

By clicking the expand button next to the database name, you can see a secondary menu of table, and click the table to expand all the data tables below the corresponding database, as shown in the following figure.

Click the right mouse button above the expanded data table, you can do some operations for the data table, such as the following figure, the editor selects the first select rows limit 1000 to query out the 1000 pieces of data in this table.

The above is the editor for you to share how to use Workbench to query mysql database, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.