Home  >  Article  >  Database  >  How to run sql file in navicat

How to run sql file in navicat

藏色散人
藏色散人Original
2019-08-22 13:52:2524995browse

How to run sql file in navicat

How does navicat run sql files?

First open Navicat on the computer

How to run sql file in navicat

Click the connection on the left

How to run sql file in navicat

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

How to run sql file in navicat

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

How to run sql file in navicat

After creation, it will be the following picture

How to run sql file in navicat

##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

How to run sql file in navicat

Then click the option to select the file

How to run sql file in navicat

Select the SQL file to be executed from the computer

How to run sql file in navicat

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

How to run sql file in navicat

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

How to run sql file in navicat

Notes

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

How to run sql file in navicat

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

How to run sql file in navicat##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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn