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

How to import sql files into navicat

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-03 10:13:195797browse

How to import sql files into navicat

After opening Navicat for MySQL, click the New link. Many unopened databases will appear. Right-click on any database and select "New Database".

How to import sql files into navicat

A pop-up window will appear, enter the name of the database, write whatever you want, select GBK for the character set, and you don’t need to select the sorting rule.

How to import sql files into navicat

Related recommendations: "Navicat for mysql graphic tutorial"

The database is now created, and then you need to right-click and select Open Database, so that the database becomes green and available.

Then pull a sql file from your computer to the corresponding database.

How to import sql files into navicat

Pull the sql file on the computer to the corresponding database, and a pop-up window will appear.

How to import sql files into navicat

Click Start, close after running, then right-click on the table in the corresponding database to refresh, and the sql file will be successfully imported into Navicat for MySQL.

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