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

This article is about navicat's method of running sql files. Xiao Bian thinks it is quite practical, so share it for everyone to make a reference. Let's follow the editor and have a look.

How does navicat run sql files?

First open Navicat on your computer.

Click on the link on the left

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

Then the corresponding information, such as username, password, connection name

Create the following picture

Import and execute SQL files

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

Then click Select File option

Select SQL file to execute from PC

After selecting, after displaying the selected file, click Start

After displaying as Finish, it means that execution is complete.

careful

After the execution, no change can be seen without refreshing, so you can refresh the database first.

If you are executing SQL files that create database tables, refresh the tables as well

Then you can see that a new table has been created

Thank you for reading! About navicat running sql file method to share here, I hope the above content can have some help for everyone, so that we can learn more knowledge. If you think the article is good, you can share it so that more people can see it!

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.