The first step is to create a new table, for example: "article".
Related recommendations: "Navicat for mysql graphic tutorial"
The second step, in the Navicat option Click "Query" in the card, then click "New Query", and then the query window will pop up, as shown in the figure below. No SQL statements are currently entered.
The third step is to enter the SQL statement in the query window to search, as shown in the figure below, trying to query the data in the article table. After writing the SQL statement, click the "Run" tab, and the query results will be displayed in the same window, as shown below:
Of course , right-click the article, you can see that there are many operations on the table, so I won’t go into details here.
The above is the detailed content of How to query the table in navicat. For more information, please follow other related articles on the PHP Chinese website!