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

Editor to share with you how to write navicat sql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Sql is a statement that manipulates data in a database, which varies slightly from database to database. Navicat for MySQL is a very convenient MySQL client tool, which can provide a visual interface to operate the database. It occupies a very high market share in the same type of software. In order to make it easier for you to learn the skills of writing sql statements in Navicat, we will teach you how to use the handle to demonstrate.

First, open navicat. In the toolbar on the open Navicat for MySQL software interface, find the "query" tool and click.

Second, open the database you want to operate, for example: I want to operate the local webdb database, as shown in the following figure.

Third, find the brightened new query (New Query), click to open, and a window pops up, as shown in the following figure.

4. Explain here that there are two tab windows in the window, one is the query Editor (Query Editor), and the other is the query creation tool (Query Builder). The former needs to write sql statements manually, while the latter can generate sql statements through visual operations.

The above is all the content of the article "how to write sql by navicat". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.