Home  >  Article  >  Database  >  How to import sql files into navicat

How to import sql files into navicat

angryTom
angryTomOriginal
2019-08-15 13:40:4627765browse

How to import sql files into navicat

Navicat is a view management tool for mysql that is widely used. Below is a record of how Navicat imports sql files.

Recommended tutorial: MySQL database video tutorial

##Method/step

1. 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 the database.

How to import sql files into navicat

2. 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 files into navicat

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

How to import sql files into navicat

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

How to import sql files into navicat

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

How to import sql files into navicat

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

How to import sql files into navicat

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