Home >Database >Mysql Tutorial >How to import sql file into mysql

How to import sql file into mysql

醉折花枝作酒筹
醉折花枝作酒筹forward
2021-06-16 09:29:234887browse

This article will give you a detailed introduction to the method of importing sql files into mysql. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

How to import sql file into mysql

The first step: Find mysql in the start interface

How to import sql file into mysql

The second step: Double-click to open the mysql software. , and enter the password.

How to import sql file into mysql

Step 3: If there is a statement to create a database in the content of the sql file or you want to store the table in your existing database, there is no need to create a database here.

How to import sql file into mysql

#Step 4: Enter "show databases;" to see the database you created.

How to import sql file into mysql

Step 5: Enter "use database name" to start using this database.

How to import sql file into mysql

Step 6: Start importing the sql file and enter the "source sql file path" (note that if your file path is copied, you must replace all "\" into "/")

Step 7: Enter "show tables" and you will see the tables you imported.

How to import sql file into mysql

Related recommendations: "mysql tutorial"

The above is the detailed content of How to import sql file into mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:csdn.net. If there is any infringement, please contact admin@php.cn delete