Home  >  Article  >  Database  >  How to import sql in navicat

How to import sql in navicat

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-09 10:49:2328288browse

How to import sql in navicat

Navicat for Mysql is a view management tool for mysql that is widely used. The following records how Navicat for mysql imports sql files.

First create a database (because the sql file I imported only has statements for creating tables and inserting data).

Right-click on the connection name to create a new database.

How to import sql in navicat

Enter the name of the database. Here I choose utf-8 encoding because I specifically selected utf-8 when I installed mysql.

How to import sql in navicat

Related recommendations: "Navicat for mysql graphic tutorial"

Double-click your newly created database to make it appear green . Then right-click on the name of the database and select Run sql file.

How to import sql in navicat

#Then click the icon as shown to find the sql file you want to run.

How to import sql in navicat

Note that when there are multiple sql files you want to run, you must pay attention to their order. For example, there is SQL to create tables first, and then there is SQL to insert data.

How to import sql in navicat

After selecting, click OK and it will run the sql statement. If successful, the following relevant information will be displayed, then click Close.

How to import sql in navicat

At this time, click on the database where you run the sql file, and then refresh with F5, and you will be able to see the effect of sql (such as table structure and data).

How to import sql in navicat

The above is the detailed content of How to import sql 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