Home>Article>Database> How does mysql import sql files?

How does mysql import sql files?

青灯夜游
青灯夜游 Original
2019-05-14 13:07:37 50412browse

How does mysql import sql files?

Mysql steps to import sql files:

1. Prepare the sql file to be imported and put it in a remembered folder , it will be easy to import in a while, as shown in the figure.

How does mysql import sql files?

2. After preparing the sql file, open the navicat tool and use navicat to connect to the mysql database; then find the database where you want to import the sql file, table->right-click ->Run the sql file as shown in the figure.

How does mysql import sql files?

3. After clicking, a pop-up box for running the sql file will pop up. Then click the browse button at the back to select the sql file you just prepared, as shown in the figure. Show.

How does mysql import sql files?

#4. Then in the pop-up system pop-up box, select the sql file you just prepared and click to open it, as shown in the picture.

How does mysql import sql files?

The above is the detailed content of How does mysql import sql files?. 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