How to execute sql in navicat

First, use Navicat for MySQL to connect to the database and create a database.

Then click Query. There are two queries here. You can click on any one.

Since we want to execute the SQL statement, we need to create a new query form first.

Related recommendations: "Navicat for mysql graphic tutorial"

As shown in the picture, this is the query editor, here You can write SQL statements to practice.

As shown in the picture, I will write a random SQL statement to demonstrate. What I wrote was a statement to create a new data table.

#After writing the exercise SQL statement, click the run button, the green icon in the upper left corner is.

#Then such an "impact" message will pop up, indicating that it is running.

#Then remember to refresh the table. Right-click on the table to refresh.

At this time you can see that the SQL statement works.

The above is the detailed content of How to execute sql in navicat. For more information, please follow other related articles on the PHP Chinese website!