How to run sql file in navicat

How does navicat run sql files?

First open Navicat on the computer

Click the connection on the left

Select the database you are using from the drop-down options

and then provide the corresponding information, such as user name, user password, connection name

After creation, it will be the following picture

##Related recommendations: "

Navicat for mysql usage tutorial"

Import and execute the SQL file

Right-click on the location of the specified database and select Run SQL file

Then click the option to select the file

Select the SQL file to be executed from the computer

After selecting, it will show that the file has been selected. Click Start

After it is displayed as Finish, it means the execution is complete

Notes

After execution, no changes will be seen without refreshing, so you can refresh the database first

If you are executing to create a database table SQL file, also refresh the table

##Then you can see that a new table has been created

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